Open a new Excel workbook
Go to the Data tab
Select Get Data or Get & Transform Data
Choose From File
Select From Workbook
Import the first Excel file
Repeat the import for each additional Excel file
In Power Query, append or combine the imported tables
Check that column names and data types match
Load the combined data into a new worksheet
Save the merged workbook
Alternatively, copy each sheet or range into one workbook manually
Use Paste Special if needed to preserve values or formatting
Rename sheets clearly to avoid confusion
Remove duplicate rows if necessary
Verify that all data is included correctly