Consolidating excel worksheets into one
Excel offers a number of ways to summarize information in different worksheets and workbooks.
Consolidate Worksheets Wizard lets you choose Excel files and data you want to work with, and it gives you a number of options to consolidate data.
Fortunately, there's another alternative: the Consolidate... You typically use it to perform summary calculations on values in corresponding cells in various source ranges.
That is, you use it to count the values in multiple ranges or to find the sum, product, minimum, maximum, variance, standard deviation, or average of the values in a group of ranges.
You can simply check off all needed worksheets and define the range you want to consolidate.
Just as in Excel, you can choose the function to apply to numbers.
The same goes for worksheets you need to have in one Excel workbook: just select all you need, they do not have to be open to be copied to one file. If each workbook you have represents a month, and you need to create one that would represent the whole year – there is an option in this wizard that will convert every workbook to one excel sheet and take them all to one new Excel sheet.