Colsolidate four workbooks into single workbook

[sai_rajr]

Hi,

Can you provide macro to collate four workbooks into single workbook.
Sheets in workbooks also to be copied. The sheet 1 of the 4 workbooks should be combined into the sheet 1 of the new workbook. Sheet 2 of the 4 workbooks should be combined into the sheet 2 of the new workbook, and so on.

Many thanks in advance.

R Sairaj
http://www.excelforum.com/attachmen...four-workbooks-into-single-workbook-epmo1.xls

http://www.excelforum.com/attachmen...four-workbooks-into-single-workbook-epmo2.xls

http://www.excelforum.com/attachmen...four-workbooks-into-single-workbook-epmo3.xls

http://www.excelforum.com/attachmen...four-workbooks-into-single-workbook-epmo4.xls

 

[sai_rajr]

Hi,

Waiting for reply.

Many thanks in advance.

Regards
R Sairaj

 

[sai_rajr]

Hi,

Waiting for reply to consolidate data from four workbooks into new single book. Please reply.

Regards,
R Sairaj