Hello there attached is your example worksheet update to include a macro that I believe accomplishes what you are looking for. To run the macro. Press Alt+F8 on your keyboard and select the test macro and then select the run option.
Please note that this code assumes that your Master worksheet is the first worksheet in your workbook.
It also assumes that the rest of the worksheet in your workbook are worksheets you wanted copied into the Master worksheet.
To insert this code
1. Press Alt+F8 on your keyboard
2. Clear the macro name field
3. Type the following in the macro name field AddToMaster
4. Select the Create option
5. In between the Sub AddToMaster() and End Sub copy and paste the following code, anything that appears in green is a comment meant to help you understand
7. Close out of VBA and then press Alt+F8 again
8. Select the AddToMaster macro and select Run.
Let me know if this works for you!
Thanks!
Bookmarks