Open the first Excel workbook
Open the other workbooks you want to merge
Create a new master workbook
Copy the sheets or data from each workbook
Paste each sheet into the master workbook
Rename sheets if needed
Check for duplicate sheet names
Use Move or Copy Sheet to transfer entire worksheets
Use Power Query to combine tables if the data is structured
Use VBA macro to automate merging multiple workbooks
Save the merged workbook with a new file name
Verify formulas, links, and formatting after merging