On the Data tab, in the Data Tools group, click Consolidate. In the Function box, click the summary function that you want Excel to use to consolidate the data. The default function is SUM. Following is an example with three worksheet ranges selected.
https://support.office.com/en-us/article/consolidate-data-in-multiple-worksheets-007ce8f4-2fae-4fea-9ee5-a0b2c9e36d9b
Data consolidation in Excel can be useful when you want to combine data from different table, even from different Excel spreadsheets. In this post you will learn how to add together data from various data table.
http://best-excel-tutorial.com/55-advanced/91-consolidation
These source areas can be on the same worksheet as the consolidation table, on different sheets in the same workbook, or in different workbooks. When you consolidate the source data, you apply a summary function, such as the SUM() function, to create the summary data. There are two ways to consolidate data: by category or by position. Consolidation by position: When the data in the source areas is arranged in the same order and uses the same labels.
https://support.microsoft.com/en-us/help/214270/how-to-consolidate-multiple-worksheets-to-a-single-sheet-in-excel
Summarize data from multiple worksheets/workbooks into one worksheet with Consolidate function. Summarize data from multiple worksheets/workbooks into one worksheet with Kutools for Excel. Office Tab: Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.Try now.
https://www.extendoffice.com/documents/excel/1186-excel-summarize-data-from-multiple-worksheets.html
Use a formula to consolidate data. 1  If the data to consolidate is in different cells on different worksheets. Enter a formula with cell references to the other worksheets, one for each separate worksheet. 2  If the data to consolidate is in the same cells on different worksheets.
https://support.office.com/en-us/article/consolidate-data-in-multiple-worksheets-007ce8f4-2fae-4fea-9ee5-a0b2c9e36d9b
Using Tabs in Excel like Firefox, Chrome, Internet Explore 10! This Consolidate feature combines values and do some calculations from multiple worksheets or workbooks into one worksheet. In the following example, I want to summarize the total score of four terms for each student.
https://www.extendoffice.com/documents/excel/1186-excel-summarize-data-from-multiple-worksheets.html
You can select up to 11 different functions for data consolidation. You just want to summarize data, so we choose Sum. The tables contain the label in the top row and left column, then select the appropriate check boxes in the dialog box. Select a check box with which you will see a link to the source data.
http://best-excel-tutorial.com/55-advanced/91-consolidation
In the Function list, select the summary function that you want Microsoft Excel to use to consolidate the data. In this example, use Sum. In the Reference box, type each source area you want to consolidate and then click Add. Type the first area, Sheet1!$A$2:$C$6 and then click Add.
https://support.microsoft.com/en-us/help/214270/how-to-consolidate-multiple-worksheets-to-a-single-sheet-in-excel
Select cell A3. On the Data tab, in the Data Tools group, click Consolidate. In the Function box, click SUM. In the Reference box, click the Collapse Dialog button (edit reference icon) and select the branch A worksheet. Select the data range A3:B27. Click the Collapse Dialog button.
https://www.sageintelligence.com/tips-and-tricks/excel-tips-tricks/2015/10/how-to-consolidate-data-in-excel-using-data-consolidation/
If you are not familiar with the Consolidate function in Excel, here I will recommend you an easy and multi-functional tool-Kutools for Excel. With its Combine feature, you can quickly summarize the data from multiple worksheets or workbooks into one master worksheet.
https://www.extendoffice.com/documents/excel/1186-excel-summarize-data-from-multiple-worksheets.html
consolidate function
On the Data tab, in the Data Tools group, click Consolidate. In the Function box, click the summary function that you want Excel to use to consolidate the data. The default function is SUM.