joining excel into 1

Hi i have 3worksheet to join

Worksheet_1

	A	B	C	D	E
190011	1	2	3	4	5
190012	1	2	3	4	5

Worksheet_2

	F	G	H	I	J
190011	1	2	3	4	5
190012	1	2	3	4	5

Worksheet_3

	K	L	M	N	O
190011	1	2	3	4	5
190012	1	2	3	4	5

by using excel is there a way to combine it into

Final

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
190011	1	2	3	4	5	1	2	3	4	5	1	2	3	4	5
190012	1	2	3	4	5	1	2	3	4	5	1	2	3	4	5

for N rows.

because i tried consolidation it will add everything

Originally Posted by jayajaya_4

it can b done thru VBA

http://www.extendoffice.com/document...-into-one.html

thanks for your quick reply,

i have tried to modify the code but somehow unable to make it paste by the new column,

Selection.Copy Destination:=Sheets(1).Range("A65536").End(xlUp)(2)

is this the code that need to be changed?

please advise