With Consolidation Assistant you can condense multiple worksheets in different workbooks into one workbook, extract multiple ranges from a number of workbooks, and can consolidate data from multiple worksheets into one worksheet. The Consolidation Assistant allows you to extract up to 10 ranges from all selected workbooks and put the output on a single worksheet. You can specify different numbers of rows and columns for each range. Each range extraction can be transposed on the output worksheet.
||Microsoft Excel 97-2010.