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.