Data Dumps compiler for matching Columns

Hey Team, Whatsup,

I am new to this group and wanted one support from you in writing a VBA code for me. i have editing knowledge in VBA.
My requirement is, I have the data for multiple projects coming in 50-60 different files from different people, I will store those excels in one folder, I wanted to run a macro which will copy the data only for the matching headers in one sheet and only for last 30 days from the day(from the dates column available in dump file, column name is "CAPILastUpdated") I am running the macro. if there is no data or any issue the file name should be appear in different sheet(error report, while copying the matching headers data it should also copy the files name in next column so that I can check back to the same file directly if I wanted to check anything. The headers are as follow I will create a template

It should copy if the Column B and F is not blank and also column E (CAPILastUpdated) should be only for 30 days from the day running

Is it too complicated

Hey Guys please let me know if there is a possibilities as such