Join various columns from two data sheets

Hi, I wish to join few columns from two data sheets using Macro function.

Sample
Sheet 1:
A B C D E
1 Headline Msg1 Msg2 Msg3 Msg4
2 Car Post Join Help AAA

Sheet 2:
A B C D E
1 SumNo Msg1 Msg2 Msg3 Msg4
2 CM001 Join Help AAA BBB

Output;
A B C D E F
1 Headline SumNo Msg1 Msg2 Msg3 Msg4
2 Car Post Join Help AAA
3 CM001 Join Help AAA BBB

Hope any ones can help. Thanks a lot