Need a macro to create summary report/review from several files???

Hi!

How to create a summary report/review from many files?

E.g. there are many files - each file includes a data of the particular day. The column names are the same, the data differs.

I need the macro to create e.g. monthly/year reports from all those many separate files which are in one folder.

I've attached some files but just with 2 columns,-

could you please point out how to modify the macro to set the range e.g. from column A to Z.

It would be great if macro include all the files in the folder.