WBmerge

Quickly combine numerous multi-sheet Excel workbooks into one new consolidated workbook. Easy to use, you will be up and running in minutes. You select the worksheets and columns to merge. Create your import scenarios once and save them to a template for fast reuse next time.
Also includes: Worksheet Split - Split a single worksheet into separate workbooks or one new multi-sheet workbook. Workbook Inspector - Quickly analyzes any .XLSX or .XLSM file and produces a high-level report of the following: Workbook Properties, Workbook Settings, Worksheet Details, Named Ranges, Pivot Tables, Tables, VBA Code & References. The software runs on your computer, so your data never leaves your control.