On the Data tab, in the Data Tools group, click Consolidate. For example, cell B2 (in distric1.xlsx) cell B2 (in district2.xlsx) cell B2 (in district3.xlsx).
Note: if you don't check Top row and Left column, Excel sums all cells that have the same position.
Click in the Reference box, select the range A1: E4 in the district1 workbook, and click Add. Repeat step 4 for the district2 and district3 workbook. Check Top row, Left column and Create links to source data.
Data consolidation is useful in cases where you want to summarize data from more than one source.
Merging multiple Excel files into one allows you to easily compare data, look through the results and create summary reports in Microsoft Excel 2010, 20.Place the resulting worksheets to one workbook to see how a difficult-to-describe task turns into an easy-to-do one. Let's imagine you have about 50 Excel files for different projects. You want to automatically copy certain sheets from each file into a master book.Working on the same project in Excel together involves tons of workbooks. With Consolidate Worksheets Wizard for Microsoft Excel it is not necessary to open all workbooks and copy/paste their sheets one by one.In addition, you can choose to copy data only for the matching columns in the sheet, which appears fist in the list on the add-in window.Some tasks are more difficult to describe than to complete.