Macro for consolidation of multiple workbooks into single workbook

[srinidhi]

Hi All,


Required a help on Macro for consolidation of multiple workbooks into different tabs of a single workbook.

I get 3 workbooks from different individuals. The workbook name contains today’s date in it.

The rows to be copy pasted from 2 workbooks are the same, but the rows to be copy pasted differs in the 3rd workbook.


Example:

XYZ Report 09-mar-11, ABC status 09-mar-11 & Status – 9-march-11.

The range to be copy from XYZ Report 09-mar-11, is A1:s90 to be pasted in the consolidated workbook XYZ Tab A1:s90


The range to be copy from ABC status 09-mar-11 is A1:s90 to be pasted in the consolidated workbook ABC Tab A1:s90.

The range to be copy from Status – 9-march-11 is A1:T25, pasted in the consolidated workbook Status Tab in A1:T25.

The range to be copy from Status – 9-march-11 is c37:D40, pasted in the consolidated workbook Status Tab in c33:d37.

The range to be copy from Status – 9-march-11 is c44:f51, pasted in the consolidated workbook Status Tab in c40:f47.


The range to be copy from Status – 9-march-11 is h44:i57, pasted in the consolidated workbook Status Tab in k40:l52.