How to merge all current and new excel sheets in a single folder

Hello,
I have in work application an option to export requests.
Each request is saved as a single xls file, but with different number of rows based on the request it self.

What i'm doing now, is opening every single file and copying the data into the main file for record keeping in a single place.

Is there a better way to do it more automated way?

Thanks.

Uploaded both files, and the final main file.

Hope you can help.

Thanks.

This version assumes your "Final" workbook is in the same folder

Please Login or Register  to view this content.

This version for if the "Final" workbook is in another folder

Please Login or Register  to view this content.

You may wish to add some code to park the processed files away in a folder elsewhere to prevent them being processed again the next time you run the code.

Copy and paste whichever one suits your needs into a standard module and run it.

BSB