If there are two or more sheets or workbooks that need to be summarized, the Consolidate command can help pull the data together onto a single sheet.
To decide which type of consolidation to use, make sure to check the sheets that are being combined. If the data in the different sheets is in inconsistent positions, then consolidate by position even if the row and column labels are not identical.
If the sheets use the same row and column labels for their categories, then consolidate by category even if the data does not have consistent positions.