Use this method to consolidate data from a series of worksheets that have different layouts but have the same data labels.
Next, in the Reference box, click the Collapse Dialog button to select the data in the worksheet.
To learn more about Templates, see: Create a template.
When you consolidate data, you are assembling data so that you can more easily update and aggregate as needed.
For example, if you have an expense worksheet for each of your regional offices, you might use consolidation to roll these figures into a master corporate expense worksheet.
To summarize and report results from separate worksheets, you can consolidate data from each into a master worksheet.
The worksheets can be in the same workbook as the master worksheet or in other workbooks.
This master worksheet might also contain sales totals and averages, current inventory levels, and highest selling products for the entire enterprise.Tip: If you frequently consolidate data, it might help to base your worksheets on a worksheet template that uses a consistent layout.