Consolidate all data in multiple worksheets of multiple workbooks in one Master file.

Hello Everyone,

I need a macro that would help me consolidate all data in multiple worksheets of multiple workbooks in one Master file.

All the workbooks will be in one particular folder. The macro should search for data in all the workbooks and consolidate it in one master excel workbook.

I am currently using both excel 2007 and excel 2010. This macro would really help reduce manual work as currently consolidating data from 45 to 50 sheets takes an ample amount of time...

I appreciate your help and support. Thank you.

Thank you for your quick reply AlphaFrog...

The addin seems very useful however given the current circumstances we have very limited resources and are not allowed to install external/additional addins.

Thats what made me think of a macro that would ask for a path where all the excel workbooks are saved and then copy all the data in the worksheets in one master data sheet.

Thank you again for your valuable input... I will surely add this addin in my personal desktop.

Thanks a Ton Sir !!!! Your support is highly appreciated.