Combining Data from 2 sheets into one using formula's

[LearnerDriver]

Hi All,

I currently have 2 sheets both containing a single column that is common. What I am trying to achieve is a index and match on this column, effectively creating one master sheet.

Sheet 1

WORKSHEET 01
VALUE W1-A	VALUE W1-B
W1-A1	W1-B1
W1-A2	W1-B1
W1-A3	W1-B1
W1-A4	W1-B1
W1-A1	W1-B2
W1-A2	W1-B2
W1-A3	W1-B2
W1-A4	W1-B2
W1-A1	W1-B3
W1-A2	W1-B3
W1-A3	W1-B3
W1-A4	W1-B3

<colgroup><col><col></colgroup><tbody>
</tbody>

Sheet 2

WORKSHEET 02
VALUE W2-B	VALUE W2-C
W1-B1	W2-C1
W1-B1	W2-C2
W1-B2	W2-C1
W1-B3	W2-C1
W1-B4	W2-C1
W1-B1	W2-C3
W1-B5	W2-C1
W1-B1	W2-C4
W1-B6	W2-C1
W1-B1	W2-C5

<colgroup><col><col></colgroup><tbody>
</tbody>

Wanted Outcome

WANTED OUTPUT TO WORKSHEET THREE
W1-A	W2-C	VALUE W1/W2-B
W1-A1	W2-C1	W1-B1 or W2-B1
W1-A2	W2-C1	W1-B1 or W2-B1
W1-A3	W2-C1	W1-B1 or W2-B1
W1-A4	W2-C1	W1-B1 or W2-B1
W1-A1	W2-C2	W1-B1 or W2-B1
W1-A2	W2-C2	W1-B1 or W2-B1
W1-A3	W2-C2	W1-B1 or W2-B1
W1-A4	W2-C2	W1-B1 or W2-B1
W1-A1	W2-C3	W1-B1 or W2-B1
W1-A2	W2-C3	W1-B1 or W2-B1
W1-A3	W2-C3	W1-B1 or W2-B1
W1-A4	W2-C3	W1-B1 or W2-B1
W1-A1	W2-C4	W1-B1 or W2-B1
W1-A2	W2-C4	W1-B1 or W2-B1
W1-A3	W2-C4	W1-B1 or W2-B1
W1-A4	W2-C4	W1-B1 or W2-B1
W1-A1	W2-C5	W1-B1 or W2-B1
W1-A2	W2-C5	W1-B1 or W2-B1
W1-A3	W2-C5	W1-B1 or W2-B1
W1-A4	W2-C5	W1-B1 or W2-B1
W1-A1	W2-C1	W2-B2 or W2-B2
W1-A2	W2-C1	W2-B2 or W2-B2
W1-A3	W2-C1	W2-B2 or W2-B2
W1-A4	W2-C1	W2-B2 or W2-B2

<colgroup><col><col><col></colgroup><tbody>
</tbody>

The closest thing I got was to use:
{=INDEX($B$3:$C$14, SMALL(IF(COUNTIF($E$3:$F$12,$C$3:$C$14), ROW($B$3:$C$14)-MIN(ROW($B$3:$C$14))+1), ROW(A1)), COLUMN(A1))}

This brings back the W1-A column correctly but not sure how to tie it up to bring back the W2-C values.

Any pointers or help would be appreciated

Cheers