Question EN

How do I merge multiple Excel sheets into one?

Answer

Copy data from each sheet and paste onto a summary sheet. For automation, use Power Query: Data → Get Data → From Workbook.

Detailed explanation

Merging sheets is a common task when consolidating reports. There are several approaches.

Manual Method (for smaller tables)

Create a new sheet for the combined data
Copy data from the first sheet (skip headers for subsequent sheets)
Paste onto the summary sheet
Repeat for remaining sheets

Power Query (Recommended)

The automated way for Excel 2016+:

Data → Get Data → From File → From Workbook
Select the current file
Select the sheets you need (Ctrl+click)
Click Combine & Load

Bonus: when source sheets change, just refresh the query.

INDIRECT for Cross-Sheet References

=INDIRECT("'"&A1&"'!B2")

Lets you reference a cell where the sheet name is stored in another cell.

02.02.2026 Excel / Google Sheets

Need a custom formula?

Describe your task — AI will generate a working formula in seconds

Generate Formula

Related Questions

How do I calculate a percentage in Excel?

Multiply the number by the percentage and divide by 100. For example, =A1*15/100 or simply =A1*15% — Excel understands both.

How do I round numbers in Excel?

Use the ROUND function: ROUND(number, decimals). For example, =ROUND(3.14159, 2) returns 3.14. For rounding up use ROUNDUP, for down use ROUNDDOWN.

How do I calculate an average in Excel?

The AVERAGE function calculates the arithmetic mean. For example, =AVERAGE(A1:A10) computes the average of a 10-cell range.

How do I raise a number to a power in Excel?

Use the ^ operator or the POWER function. For example, =2^3 or =POWER(2,3) — both return 8 (two cubed).

How do I get the absolute value in Excel?

The ABS function returns the absolute value of a number. For example, =ABS(-15) returns 15, and =ABS(15) also returns 15.

Great formula!

Sign in to save formulas and get more free requests

Sign in for free