joining excel into 1

Hi i have 3worksheet to join

Worksheet_1

Please Login or Register  to view this content.

Worksheet_2

Please Login or Register  to view this content.

Worksheet_3

Please Login or Register  to view this content.

by using excel is there a way to combine it into

Final

Please Login or Register  to view this content.

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,

Please Login or Register  to view this content.

is this the code that need to be changed?

please advise