From a "process" point of view, I'd think pressing buttons on each sheet to transfer data to the Summary would quickly lead to duplications and errors. I would think it would be better to have the SUMMARY sheet collect it's own data for you fresh each time you look at the Summary sheet. This way you can make edits and updates to the existing data already on each of the individual sheets, and the next time you look at the SUMMARY those updates will be there as well.

We would create a Worksheet_Activate macro in the SUMMARY sheet module that triggers itself each time you view the sheet. It would clear it's current data, then run through all the sheets and copy the data in anew, skipping the sheets "Sheet1" and "Summary" as it copies.

Would that work for you? No buttons!