Open the source workbook.
Open the workbook that will contain the consolidated data.
Select the destination range.
Click the Data tab. Then click the Consolidate button.
Click the Function list arrow, and then select the function for consolidating data.
Type the location of the data.
Or click the Expand Dialog button.
Click Add to add the reference to the list of consolidated ranges.
Select the Create links to source data check box.
Click OK.