Compare 2 or more worksheets by Key and then select required column values

Hi,

Let say worksheet1 and worksheet2 which is having the matched keys or not matched keys. Please find the below example.

My requirement is to match Worksheet1 and Worksheet2 by column A and get the both matched and non matched values like as shown in Worksheet3 Output.

Please suggest me any macros solution for this requirement.

Example:

Worksheet1

Col A Col B
111 XXXX
222 YYYY
333 ZZZZ
444 XXXX
555 FFFF


Worksheet2

Col A Col B
111 AAAA
333 BBBB
777 CCCC
999 DDDD

I need to get a output as below in another worksheet say 3

Worksheet3 - Output
Col A Col B Col C
111 xxxx AAAA
222 yyyy
333 zzzz BBBB
444 xxxx
555 FFFF
777 CCCC
999 DDDD


Thanks in Advance,
Raki

-