VBA copy specific worksheet in each from multiple workbooks in the same folder

[Donaldducks]

Hi all,

I would like to write a vba to specifically explore the 'report' tab in the same folder (About 100 workbooks). All the data is the same formula in the report tab. Column A1:N1 is the header and A2:N2 is the data (ex: A1 - Account Number, A2: 123456 - as the account #, B1 - Name, B2: ABC Company).
So the end result should be A1:N1 as the column name and A2:N100 should be all the different data (ex: A1 account number, A2:A100 are all the diff account number)

Thank you!!