Consolidating entries worksheet
To learn more about Templates, see: Create a template.
This is also an ideal time to set up your template with Excel tables.
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.
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.
To summarize and report results from separate worksheets, you can consolidate data from each into a master worksheet.
Consolidation by position: When the data in the source areas is arranged in the same order and uses the same labels.Click the worksheet that contains the data you want to consolidate, select the data, and then click the Expand Dialog button on the right to return to the Consolidate dialog.