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!