Macro to copy each worksheet data from Workbook1 to Master Workbook which has same sheets

[figo12]

Hi I would appreciate your help in order to create a macro with the following purpose:

1) Automatically copy all data from each worksheet from workbook#1 to a master workbook that already has the same worksheets names as Workbook #1

Example:

All data from Worksheet "Test" in Workbook#1 should be pasted to Worksheet "Test" in Master Workbook.

There are about 50 same worksheets names in both workbooks.

Thanks very much!

[JBeaucaire]

Something like should you get almost there:

Please Login or Register  to view this content.