I understand about the data to be copied. What I don't understand is where the data is to be pasted in the Paste worksheet. Your explanation makes no sense to me. To get you started, here is the copy and paste code (filtered) and pastes it to the second sheet of the first file in cell A1 as I did not understand your paste issue. You can modify this as needed.
Sub A_()
Range("A1:D1").AutoFilter
ActiveSheet.Range("$A$1:$D$47").AutoFilter Field:=1, Criteria1:="Tier1App"
ActiveSheet.Range("$A$1:$D$47").AutoFilter Field:=3, Criteria1:="T"
Range("A2:D17").Copy Sheets("Sheet2").Range("A1")
End Sub
Bookmarks