Consolidator  
This useful tool makes easy the process of to consolidate information proceeding from different workbook. but from the same range.

Do this:

1. Click on Consolidator button.
2. Click on workbook(s) that we are going to consolidate
3. Then we choose the sheets from that workbook and add them, using the arrows button.
You will be able to see them in the right field of the dialog box.
 
 
The surrounded area by red rectangle shows workbooks and sheets to consolidate and the cell/range that we take from each sheet.

3. We choose the mathematical operation we want to perform.
4. Results can be showed by 3 manners:
- As values
- As formulas or
- As links.

See the below image.
 
 
Finally, press the Consolidate button and the results will be displayed.

NOTE:
Also, Consolidator tool allow you to make following operations:

a). Saving the most used models in a very hidden sheet in order to the next time you wish execute the same model, simply you choose it from the saved list of saved
models Learn how to do it.

b). Copying models from other workbook. Learn how to do it.

Close window