Question: how to copy from one excel sheet to another with filter?
Answer: Activate sheet 2 (where the data goes)
Choose Data > Advanced Filter.
Select the List Range on sheet 1.
Select the Criteria range on sheet 1.
Select the radio button: Copy to another location.
Select the Copy to range on sheet 2.
Click OK.