Open a new Excel workbook
Go to the Data tab
Select Get Data or Get & Transform Data
Choose From File
Select From Folder
Browse to the folder containing the Excel files
Click OK
Click Combine or Combine & Load
Choose the worksheet or table to merge
Confirm the sample file settings
Load the combined data into Excel
Save the merged workbook
Alternatively, copy each sheet from each file into one workbook
Use Move or Copy Sheet to place sheets into a single workbook
Save the final combined file