Excel makes it easy to combine more than one sheet into a new workbook:
- Open the sheets you want to merge.
- Click Home > Format > Move or Copy Sheet.
- Use the dropdown menu to select (new book).
- Click OK.
Excel makes it easy to combine more than one sheet into a new workbook: