Id be happy to help but need your help to do so. Please post a sample file that contains the structure and dummy data on a couple sheets. Do not worry about a destination sheet ill create it. I just need to know what your tables look like and have some data in it for testing.

Also lets talk about how you perceive using this. Is this as simple as just take x sheets and combine them, then your done or are you looking to do something more advanced?

You mention buttons at the top of each sheet, why? Do you want to click the button on a given sheet to move the data over to the consolidated sheet? If so, does the data stay once moved or do we clear it out (leaving the headers)?