[Solved] Consolidating of Excel files

Hello,

I want to consolidate the excel files data on sheet 1 to a new workbook one below the another.

Daily i have 10 files to consolidate in a new excel workbook to work on.

Please help me in getting a macro to copy and data and fixed it into a common excel file.

Attached is the excel files to be consolidated.

Thanks
Abdul