Open the workbook containing the sheets
Decide whether you want to combine data into one sheet or merge entire sheets
Create a new worksheet for the merged data
Copy the data from the first sheet
Paste it into the new worksheet
Repeat for each additional sheet
Ensure each sheet has the same column headers and layout
Use Paste Special if you need to preserve values, formats, or formulas
Use Power Query to append tables from multiple sheets
Convert each sheet range into an Excel table before merging
In Power Query, load each table and choose Append Queries
Use Consolidate from the Data tab if you want to combine summarized data
Use VBA if you need to automate merging many sheets
Save the merged workbook after checking for duplicate headers and blank rows