Consolidating multiple speadsheets to one file

[ssanjju]

My excel challenge in the office on a daily basis is that I receive multiple dataset excel spreadsheets which contain data in a similar pattern but the volume or the number of rows is a variant. I have to consolidate all the datasets into one single excel file. Please find attached three sample files and please help me with a macro code that can be used so that all the files gets consolidated to one file.

Thank you in advance.

[Pepe Le Mokko]

You can use Ron de Bruin's add-in