Combine Data from Multiple Sheets to A Sheet | Dan Wagner Co - Free Printable

You're working in Excel and have multiple worksheets (`IOAccess`, `MemoryDisc`, `Peripherals`) that all share the same structure (same headers: Date, Reporter, Item, Notes) but contain different data. Your goal is to combine all the data from these sheets into a single sheet (likely the "Import" sheet, as indicated by your annotation).

Here’s how to solve this step-by-step:

---

✔ Goal

Combine data from multiple sheets (`IOAccess`, `MemoryDisc`, `Peripherals`) into one consolidated sheet (`Import`), preserving the format and headers.

---

## 🔧 Solution: Use Power Query (Recommended)

Power Query is the most efficient and scalable way to combine data from multiple sheets with identical formats.

📌 Step-by-Step Instructions

#### 1. Select All Sheets
- Make sure you are on the "Import" sheet.
- Go to the Data tab → Click Get Data → From Workbook → Browse.
- Select your current workbook (e.g., `combine_sheets_into_one.xlsx`) and click Open.

> This will open a dialog showing all sheets in the workbook.

#### 2. Choose the Sheets to Combine
- In the Navigator window, check all the sheets you want to combine:
- `IOAccess`
- `MemoryDisc`
- `Peripherals`
- Uncheck any unwanted sheets.
- Click Load or Transform Data.

> If you click Transform Data, it opens the Power Query Editor.

#### 3. Combine Tables in Power Query
- In the Power Query Editor, you’ll see each selected sheet as a separate table.
- Right-click on any of the tables → Append Queries as New.
- Choose "Append Queries" → Select "All" (or manually select all three).
- Click OK.

> This merges all three tables into one.

#### 4. Clean Up & Load
- Ensure the combined data has consistent headers and no duplicates.
- Remove any extra columns if needed.
- Click Close & Load to load the combined data into the "Import" worksheet.

---

✔ Result

All data from the three sheets will now be stacked vertically in the "Import" sheet, like this:

| Date | Reporter | Item | Notes |
|------------|----------|-------------------------------------------|---------------|
| 1/11/2016 | RC | 37fbab3-... | Added |
| 1/11/2016 | RC | 58d3751d-... | Status Check |
| ... | ... | ... | ... |
| 1/17/2016 | RC | 0dd77b5f-... | Status Check |

---

## 💡 Alternative: Manual Copy-Paste (Not Recommended for Large Data)

If you don’t want to use Power Query:

1. Copy data from `IOAccess` → Paste into `Import`.
2. Copy data from `MemoryDisc` → Paste below existing data.
3. Repeat for `Peripherals`.

⚠️ Drawbacks: Error-prone, not dynamic, hard to update later.

---

## ✔ Bonus: Automate with VBA (Advanced)

If you frequently need to do this, you can write a simple macro:

```vba
Sub CombineSheets()
Dim ws As Worksheet
Dim DestSheet As Worksheet
Set DestSheet = ThisWorkbook.Sheets("Import")

For Each ws In ThisWorkbook.Worksheets
If ws.Name <> "Import" Then
ws.Range("A2:D" & ws.Cells(ws.Rows.Count, "A").End(xlUp).Row).Copy
DestSheet.Cells(DestSheet.Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
End If
Next ws
End Sub
```

> Run this macro after ensuring the first row (headers) is already in the "Import" sheet.

---

## ✔ Summary

| Method | Pros | Cons |
|----------------------|-------------------------------|------------------------------|
| Power Query | Dynamic, clean, easy to update | Requires learning Power Query |
| Manual Paste | Simple | Not scalable, error-prone |
| VBA Macro | Fully automated | Needs coding knowledge |

✔ Best Choice: Use Power Query — it's built for exactly this task and keeps your data organized and updatable.

Let me know if you'd like a video guide or help setting up Power Query!