Do you wish to consolidate data come from many sheets contained in more than one workbook?
and, besides, the records are disordered?
Then, this tool will make it for you.
Let's see an example:
Suppose, that I want to consolidate data contained in 2 workbooks,
These workbooks are named: "Example_01.xls" and "Example_02.xls" respectively.
In order to use this tool, first, I must name to each range to be consolidated.
In this example, the ranges' names are the following ones:

See the named ranges to use:

Note that if the selected named range(s) is located in workbooks different, then the consolidation will be done in a new workbook.

The result is a pivot table con the wished consolidation.
If we had chosen "Paste results as... Static table" then the results would be showed in a simple table.