Afterwards, it consolidates the same range from each sheet in a new sheet (in case of a new workbook) or in the selected sheet (in case of a open workbook)

we can automatize the process of consolidating our information immediately.

This way:

1. We must to have 2 open workbooks or more
2. Click on Multi-sheets Consolidator
3. Select all of sheets you wish to consolidate.
4. Choose the mathematical operation that you want to apply over the data.
5. Choose how you want to paste the results. As values, as formulas or as links.
6. Then, choose the range you wish to take from the selected sheets.
7. Press on Ok button.
That is all.

Close window