If your data contains labels for top row and left column, please check Top row and Left column under Use labels in.
You can also enable Create links to source data option, for linking the source data(this option is applied to new workbook ), see screenshot: 4. All the data from the worksheets has been added-up into a new worksheet.
Then the result of consolidation will be displayed in the target worksheet.
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.
For example, in the example workbook, the first two worksheets are 2012 Data and 2013 Data.
We want to consolidate data in the first two worksheets and put the result in the Total Sales worksheet.