Need to Copy/Consolidate Multiple Tables on to a seperate sheet or table

[Slinky84]

I have a spread sheet setup to track the amount of car sales that as a business we do. Each sheet is named by the month but I need to also have a separate page with all the data combined. I have everything in tables at the moment. however I cannot find a formula to do what I need. Any suggestions?

Thanks,

SteveFI Worksheet FAKE.xlsm

[Rob Kennedy]

Which cell do you want your first answer on? Are you talking about C37 on the Control sheet?

[Slinky84]

I need the new answer to be on a separate sheet. I need all the data from all the months on one sheet but still keep the separate months running. The control sheet is a sheet I use to populate the summary sheet and is normally hidden.

Thanks