4 ways to merge Excel sheets into one

Copy data from multiple worksheets at once

One tool, four different ways to merge multiple Excel sheets into one. You just specify how you want to combine spreadsheets,
and let the Copy Sheets add-in do the rest. What used to be a daunting task for many Excel users is now a simple few-clicks operation.
No more copying and pasting, no more manual re-entry of data, no more errors.

There is a build-in command Move or Copy Sheet, which is sufficient if
you merge sheets from one workbook. In case you have many workbooks and need to copy sheets from
each of them, working with Move or Copy command will be rather time-consuming. With Copy Sheets
you can copy tables from different worksheets and workbooks simultaneously, so the more books
and sheets you have, the more working hours will be saved.

Excel Consolidate feature can be helpful to pull together data from several worksheets,
but it works for numeric values only and you have to choose the function: sum, count, average,
etc. If you need to merge data by just copying values, the consolidation option won't help.

Of course, you can always use copy-pasting, but again, it is great for a little number
of sheets and books, but could be rather wearisome when you have dozens of them.

On Step 2 you select the worksheets, workbooks and ranges to copy. You can add any Excel files
to the list.

On Step 3 you choose how to paste data (paste formulas or values only, create links to
source data), how to place the values (to columns or to rows), and how to copy data (preserve
formatting, separate the copied ranges by a blank column, copy table with their headers).

You click Copy button and in a couple of seconds get the new workbook with all
the copied ranges.