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
Choose the sheet or table to merge
Review the preview
Click Load to import the combined data into one workbook
Save the merged workbook
Open the first Excel file
Copy the data you want to merge
Open the destination workbook
Paste the data into a new sheet
Repeat for each file
Make sure column headers match
Save the final workbook
Use Power Query for files with the same structure
Use copy and paste for a small number of files
Use VBA macro for automated merging of many files