Consolidate data from multiple worksheets

1. Ensure each range of data is in list format with labels in the first row and no blank rows or columns.

2. In the master worksheet, select the upper-left cell where you want the consolidated data to appear.

3. On the Data tab, select Consolidate in the Data Tools group.

4. In the Function box, choose the function you want to use for consolidation (e.g., Sum, Average).

5. In the Reference box, select the data ranges you want to consolidate, then select Add. Repeat for all ranges.

Note: To update the consolidation table automatically when source data changes, check the Create links to source data box.

For more details, see Consolidate data in multiple worksheets.

1. Ensure each range of data is in list format with labels in the first row and no blank rows or columns.

2. In the master worksheet, select the upper-left cell where you want the consolidated data to appear.

3. On the Data tab, select Consolidate in the Data Tools group.

4. In the Function box, choose the function you want to use for consolidation (e.g., Sum, Average).

5. In the Reference box, select the data ranges you want to consolidate, then select Add. Repeat for all ranges.

For more details, see Consolidate data in multiple worksheets.

[Feature] isn't currently possible in Excel for the web. You can, however, [Feature] in the Excel desktop app.

• To open the desktop app, select Editing and choose Open in Desktop App at the top of the ribbon. If you don't see Editing, select  More Collaboration Options.

  

Don't have the Excel desktop app? Try or buy Microsoft 365.