Require a VBA macro for workbook consolidation

[addepallibabu]

Hi All,

I have 50 workbooks, all are with two sheets and every sheet have header and below that some data in rows wise. I need to compile all the 50 workbooks in one workbook with two different sheets. i.e., all sheet1 data into sheet1 and all sheet2 data into sheet2. Can any one help in this regard. Thanks.

Regards,
Suresh