Consolidate data in Excel
in the same workbook
Let’s say we have a workbook that contains multiple sheets of sales data for some products by region.
Now we would like to consolidate each region into one main summary table.
This table gives us the sum total of all the products.
We have sales numbers for the first three months of the year.
These numbers are for 4 different products, A, B, C, and D.
Each of four regions, North, South, East, and West have sales figures for all the products. Each region’s table is in its own worksheet.