📁 🧩
📁 Excel Combine Guide

How to Combine Multiple Worksheets into One Workbook in Excel

To combine multiple worksheets into one workbook, open every source file, then Move or Copy each sheet into a single target workbook — or run a VBA macro to do it in bulk. The result is one workbook that keeps every sheet separate. (Need to merge rows into one sheet instead? Use the combine-into-one-sheet guide below.)

🚀 Start Combining 💻 View VBA Method
⚡ Manual + VBA 📁 Keeps Every Sheet Separate ✅ Works on Excel 365 / 2024
FIRST, PICK THE RIGHT TASK

One workbook vs. one sheet — these are different jobs

This page is about combining multiple worksheets into one workbook (a single file that keeps each sheet as a separate tab). If you instead want to stack the data rows from several sheets into one table, that is a different task.

You want to…ResultWhere to go
📁 Combine worksheets into one workbook One .xlsx file, multiple sheet tabs This page
📋 Merge data rows into one sheet One sheet, all rows stacked Combine Worksheets into One Sheet →
QUICK DIAGNOSIS

What's your combining goal?

Your Goal Recommended Method Key Consideration
🖱️ Combine 2–3 workbooks manually Move or Copy ✅ No code — open all files first
⚙️ Combine many workbooks at once VBA Macro ⚠️ Backup first, for advanced users
⚠️ Critical Warning: Always back up your source workbooks before combining. If you forget to check "Create a copy", you will MOVE the sheets out of their original workbook instead of copying them.
COMBINE METHODS

Choose Your Method

Move or Copy Sheet (Manual, No Code)

Best for combining a handful of workbooks when you want full control over each sheet.

1

Open All Workbooks

Open every source workbook and the target workbook where the sheets should end up. The target must be open or it won't appear in the list.

2

Select All Sheets in a Source Workbook

Click the first sheet tab, hold Shift, then click the last tab. This selects every sheet in that workbook.

3

Right-Click → Move or Copy

Right-click one of the selected tabs and choose Move or Copy.

  • To book: select the target workbook
  • Before sheet: choose where the sheets should land
  • ✅ Check "Create a copy" — leaving it unchecked MOVES the sheets
4

Repeat & Save

Repeat steps 2–3 for each source workbook, then save the target workbook. Each sheet now lives in one file as a separate tab.

✅ Pro Tip: To keep things tidy, rename duplicate sheets afterward. Excel appends "(2)", "(3)" etc. when names collide — right-click a tab → Rename to fix.
💡 Related: For the single-sheet mechanics of Move or Copy, see the Copy a Worksheet guide.

VBA Macro (Batch Combine Many Workbooks)

Automate combining every worksheet from all open workbooks into one master workbook.

⚠️ VBA Warning

VBA operations cannot be undone! Always back up your files before running macros. Only suitable for users familiar with VBA.

1

Prepare the Master Workbook

Create a new blank workbook, save it as Master.xlsm (macro-enabled). Open all the source workbooks you want to combine.

2

Open the VBA Editor

Press Alt + F11 (Windows) or Fn + Option + F11 (Mac).

3

Insert a Module & Paste the Code

Click Insert → Module, then paste:

Sub CombineWorkbooksIntoSingle()
  Dim wb As Workbook
  Dim ws As Worksheet
  Dim master As Workbook
  Set master = ThisWorkbook
  For Each wb In Application.Workbooks
    If wb.Name <> master.Name Then
      For Each ws In wb.Worksheets
        ws.Copy After:=master.Worksheets(master.Worksheets.Count)
      Next ws
    End If
  Next wb
  MsgBox "All sheets combined into " & master.Name
End Sub
4

Run the Macro

Press F5 to run. Every worksheet from the other open workbooks is copied into the master workbook.

✅ Pro Tip: This macro copies sheets from all open workbooks. Close the source files you don't want included before running it.
TROUBLESHOOTING

Common Problems & Fixes

The "To book" dropdown is empty

Your target workbook isn't open. Open it first, then reopen the Move or Copy dialog.

Sheets get "(2)", "(3)" added to their names

That's Excel handling duplicate names. Rename each sheet afterward, or give source sheets unique names before combining.

"Move or Copy" is grayed out

The workbook is likely protected. Go to Review → Unprotect Workbook first, or see the Unprotect Worksheet guide.

Some sheets didn't come over

Hidden sheets aren't selected with Shift+click. Unhide the sheets, then combine.

Formulas now show #REF! errors

Formulas that referenced the old workbook may break. Check and re-point any external references in the combined workbook.

FREQUENTLY ASKED

Frequently Asked Questions

What's the difference between combining worksheets into one workbook vs one sheet?
Into one workbook keeps every worksheet as a separate tab in a single .xlsx file. Into one sheet merges the data rows into a single table. Choose "workbook" to consolidate files, and "sheet" to merge data.
How do I combine multiple Excel files into one workbook?
Open all the files, then for each source workbook select all its sheet tabs, right-click, choose Move or Copy, select the target workbook in "To book", check "Create a copy", and click OK. Repeat for each file.
Can I combine worksheets from many files without opening each one?
Yes, with a VBA macro that loops through a folder of workbooks and copies each worksheet into a master workbook. This automates combining many files at once.
Will combining worksheets into one workbook break my formulas or formatting?
Move or Copy preserves formatting, charts, and most formulas. Formulas that reference other workbooks may change to the new workbook; check them after combining.
How do I avoid duplicate sheet names when combining?
Excel auto-renames duplicates by appending "(2)", "(3)", and so on. Rename each sheet after combining, or rename source sheets to unique names beforehand.
Does combining worksheets into one workbook work on Mac?
Yes. Right-click (or Control+click) a sheet tab, choose Move or Copy, and follow the same steps. VBA macros work on Mac but may need minor code adjustments.
CONTINUE LEARNING

Combined Your Workbook? Keep It Organized!

📑

Group the Sheets

Edit many sheets in the combined workbook at once. Master batch operations.

Learn More →
🛡️

Protect the Workbook

Lock your combined workbook so no one breaks the structure or formulas.

Learn More →
🔀

Merge into One Sheet

Need all rows in a single table instead? Use Power Query, VSTACK, or VBA.

Learn More →
QUICK LINKS

Continue Exploring

📄 Copy a Worksheet 🔀 Combine into One Sheet 📑 Group Worksheets 🛡️ Protect Worksheet 🔓 Unprotect Worksheet 👁️ Unhide Worksheet 📊 All Excel Guides About Us
SOURCES

Sources & References

Written and fact-checked against Microsoft's official Excel documentation.

Disclaimer: This guide is for informational and educational purposes only. Always back up your files before batch operations. Last Updated: September 10, 2026.

We use cookies to analyze traffic. By continuing you agree to our Privacy Policy.

People Also Ask About Combining Worksheets into One Workbook in Excel

How do I combine multiple worksheets into one workbook without copy-paste?

You don't need to select cells and copy-paste. Select all the sheet tabs (click the first tab, hold Shift, click the last), right-click → Move or Copy → pick the target workbook and check Create a copy → OK. Or run a VBA macro that loops through the workbooks and copies each sheet automatically.

Can I combine Excel workbooks using Power Query?

Yes, but Power Query merges the data rows into one table rather than keeping each sheet separate. Use Power Query (Data → Get Data → From Folder) when you want a single combined sheet; use Move or Copy when you want one workbook that keeps every sheet as its own tab.

Why can't I move or copy a worksheet in Excel?

The most common reasons are: (1) the workbook is protected — go to Review → Unprotect Workbook; (2) it's in Shared mode — go to Review → Unshare Workbook; (3) the sheets are hidden and not selected. Fix these first, then Move or Copy works.

How do I move all sheets from one workbook to another?

Click the first sheet tab, hold Shift and click the last tab to select every sheet, then right-click a selected tab → Move or Copy → in "To book" choose the destination workbook → leave "Create a copy" unchecked to MOVE them → OK.