Click button to select the range you want to summarize one by one.
(By default, the used range is selected for each worksheet) See screenshot: 3.
Kutools for Excel with more than 120 handy Excel add-ins, free to try with no limitation in 30 days. After installing Kutools for Excel, please click Enterprise Combine. In the Combine Worksheets wizard, select Consolidate and calculate values across multiple workbooks into one worksheet. On step2 of wizard, all the opened workbooks and worksheets are listed in the list boxes, you can click Add button to add other files or folders that you want to consolidate.
Shown as follows: Figure 6 Add the 2013 Data cells area Step 8 Press OK.
Then the result of consolidation will be displayed in the target worksheet.
Here, I will introduce you some quick tricks to solve it.
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 This Consolidate feature combines values and do some calculations from multiple worksheets or workbooks into one worksheet.