Hi all,
I have a workbook containing 3 worksheets. Each worksheet contains a table. The column headers of the tables are consistent across all 3 worksheets. Basically, I want to add a 4th worksheet which dynamically adds each existing and new line from the 3 separate tables.
The table has 8 column headers with many many rows of data entered. They are:

Fiscal Year
Fiscal Month
Fiscal Week
Week Beginning
Store name
Product Cat
Product
Sales Units

The only item that can be 'summed' is the sales units column, so the Data>Consolidate feature does not work for me and I receive some very strange results.

Any ideas? I have searched everywhere. I don't really want to use a separate excel add-in as I am creating this centrally for use in countries where the add-in will not be available.

Thank you in advance for your help!!!