Hi,

See if this works for you.
You will see a "Run" button. When you click it the code will copy all of the required sheet to "Summary". As you can see I renamed 2 of the worksheet. I also removed the "Hidden" columns.
If you rerun the code the data in the summary sheet will copy to the last row. In other it will keep adding to the Summary. You will need to clear the Summary sheet before you run the code again.
You can also set a New button that when clicked to remove the existing data in the Summary sheet.

Attached Files

Summary (1).xlsm (85.5 KB, 13 views)