I would like to merge data from two worksheets into one worksheet based on a
key data value. Here is the data:

Worksheet 1

ColA ColB
DAVE 001
SAM 001
JIM 001
MARY 002
WENDY 002
JUANA 003


Worksheet 2

ColA ColB ColC ColD
001 life 1 01-Jan
002 health 2 01-Mar
003 disability 3 01-Feb

In a third worksheet I want to merge the data to get the following:

ColA ColB ColC ColD ColE
DAVE 001 life 1 01-Jan
SAM 001 life 1 01-Jan
JIM 001 life 1 01-Jan
MARY 002 health 2 01-Mar
WENDY 002 health 2 01-Mar
JUANA 003 disability 3 01-Feb


You will notice that the data is merged based on the link between Col B from
Worksheet 1 and ColA in worksheet 1. I know this is easily done in a
database but I need to do it in Excel.

Is this possible.

Thanks in advance for your help.

Attila