Before you start: if your worksheets are identical, it's probably easier to create 3D-references (if you have one workbook) or External References (if you have multiple workbooks) to consolidate your data. However, the beauty of the Consolidate feature is that it can easily sum, count, average, etc this data by looking at the labels.
Because our worksheets are not identical, we want Excel to sum cells that have the same labels.
From the list of available templates, you can click the template you want to use as the model for your workbook.You can use Excel's Consolidate feature to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet. If you check Create links to source data, Excel creates a link to your source data (your consolidated data will be updated if your source data changes) and creates an outline. Below you can find the workbooks of three districts. The worksheet information has been added before the data. see screenshot: And then all the selected worksheets in the workbooks have been merged into a new worksheet of a workbook. If you don’t want to save this scenario, please click No.