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.