Consolidator Wizard

 
This tool has three consolidation options, and one option to copy only the sheets of several workbooks in one single workbook.
 

 
We are going to explain now what each option does:
 
1.- Consolidate the selected sheets from one or several workbooks (opened or closed) in one sheet.
You can consolidate several sheets from several workbooks -whether open or closed. The resulting consolidation is shown in one single workbook and one single sheet, as shown in the following figure:
 

 
2.- Consolidate the selected sheets from several workbooks (opened or closed) in one sheet per workbook.
You can consolidate selected sheets in different workbooks into one single workbook. The results are shown in one sheet with the name (or part of the name) of each workbook containing the sheets to be consolidated, as shown in the following figure:
 

 
3.- Consolidate sheets with the same name in several workbooks (opened or closed) in sheet's groups with the same name.
You can consolidate sheets with the same name in several workbooks -whether opened or closed. The results are shown in one single workbook with sheets with same name being consolidated into one single sheet, as seen in the next image:
 

 
4.- Copy the sheets of several workbooks in just one workbook.
You can copy sheets from several workbooks -either closed or open- in one single workbook.
Workbooks from different Excel versions are validated, since Microsoft Excel 2007 has a different number of rows and columns from prior versions.
 

 
Once you have selected an option, click the Next>> button.
From this dialog, check the options before consolidating.
 

 
Select the workbooks and sheets to consolidate.
 

 
Then click OK.