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).
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.However helpful it is to check and view data parts individually, we sometimes need to combine them to create a Pivot Table, chart, or report in Excel.Say, you have multiple sheets in numerous Excel workbooks. However the order and number of columns may differ in some of them.In addition to the standard feature, it lets you select many spreadsheets and automatically pick the same range for identically structured sheets Often it is necessary to combine data from several worksheets into one master table.
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.
Simply install the add-in and now you can easily: Consolidating data from multiple worksheets into one is no longer a challenge!