Combine data sheet

[Apple Ling]

Hi, i have few data sheets with one primary key. I wish to combine these data sheets into one sheet based on the primary key. For example,
Sheet 1
ID Msg1 Msg2 Msg3
A001 ABC XYT UYT
A001 ABC UYU JJU
A002 RTU UYU JJU

Sheet 2
ID Source
A001 Annie
A001 Penny
A002 Raymond

Output
ID Msg1 Msg2 Msg3 Source
A001 ABC XYT UYT Annie
A001 ABC XYT UYT Penny
A001 ABC UYU JJU Annie
A001 ABC UYU JJU Penny
A002 RTU UYU JJU Raymond

I hope anyone can help. Thanks in advance

[JBeaucaire]

Straight INDEX/MATCH formula. Assuming you're pulling that data onto Sheet1 in column E, in the E2 put this formula and copy down:

=INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0))

...and copy down.

(No, this won't work...will require VBA to do this simply)

[JBeaucaire]

Doh! You said "primary key" so I falsely assumed (didn't look close enough) that column was UNIQUE. I see in your example it is not. Is there any UNIQUE correlating key at all or is this all duplicated like in your example?

[Apple Ling]

Sorry, may be my explanation confuse you. Please look at the sample file.

Thanks