Consolidate ranges
With this tool you can consolidate ranges of different sheets in the open workbooks as closed workbooks as well.
Use instructions:
1. In the appearing window press the button:
The window Select Workbooks & sheets should be open:
2.The sheets that you will include in the consolidation must be chosen. You can also reference them from a file, to this end you should navigate and choose the button.
The ranges must have the equal headboards, so that the consolidation can work correctly.
Example:
-Select the headboard of ranges from any of the mentioned sheets.
3.-Click on the OK button.
Finally this is the result.
The ranges of its 3 sheets have been consolidated in one sheet.