Open a new Excel workbook
Go to the Data tab
Select Get Data
Choose From File
Select From Folder
Browse to the folder containing the Excel files
Click OK
Click Combine and Transform Data
Select the sheet or table to merge
Review the preview
Click Close & Load
Use Power Query to combine the files into one workbook
Or open the first workbook
Copy the sheets or ranges from the other files
Paste them into the target workbook
Rename sheets as needed
Save the merged workbook
Use VBA if you need to merge files repeatedly
Use a third-party merge tool if preferred