Multiple sheet merger into 1 sheet

[Harini1100]

Hello All,

I've a excel which contains day wise sales sheet for the particular month. I need all the dates into one sheet within the same excel or new excel sheet. Is there any formula or shortcut? Please help on this.

Note: Each sheet have the same column headers
Thanks in advance !

 

[alansidman]

Use Power Query to append the tables into one table.

 

[kevin9999]

If you're not keen on Power Query, and you do have 365 (one of the versions you have listed on your profile) then you could use Vstack. Firstly, convert your sheets 1 & 2 to tables (I've called the tables Branch1 and Branch2 for simplicity) and use Vstack on the third sheet to combine them; like this:

Book1
	A	B	C	D	E	F	G
1	Name	Unit	Sold	Closing	Column1	Branch Code	Supervisor
2	Rubber	25	10	15		1A2345	John
3	Wax	10	2	8		1A2345	John
4	Paint	32	28	4		1A2345	John
5
Sheet1

Cell Formulas
Range	Formula
D2:D4	D2	=B2-C2

Book1
	A	B	C	D	E	F	G
1	Name	Unit	Sold	Closing	Column1	Branch Code	Supervisor
2	Rubber	12	8	4		2DC465	Mark
3	Wax	22	14	8		2DC465	Mark
4	Paint	25	10	15		2DC465	Mark
5
Sheet2

Cell Formulas
Range	Formula
D2:D4	D2	=B2-C2

Book1
	A	B	C	D	E	F	G
1	Name	Unit	Sold	Closing		Branch Code	Supervisor
2	Rubber	25	10	15	0	1A2345	John
3	Wax	10	2	8	0	1A2345	John
4	Paint	32	28	4	0	1A2345	John
5	Rubber	12	8	4	0	2DC465	Mark
6	Wax	22	14	8	0	2DC465	Mark
7	Paint	25	10	15	0	2DC465	Mark
8
Sheet3

Cell Formulas
Range	Formula
A2:G7	A2	=VSTACK(Branch1,Branch2)
Dynamic array formulas.