Filter data copy specific column to new sheet

[vikas_newports]

Hello
I have multiple files with same format and I want to perform below work for every file
Copy E2 to Macro file Sheet 2 (A1)
Apply filter on Row 9(header)
filter the dates after 31-mar-2021 on Column C
on filtered data copy the amounts from Column F without Header and paste as transpose to new macro file Sheet2 (B1)

 

[vikas_newports]

any expert