SHEET 1
record number access
1 red
2 yellow
3 blue
4 grey
5 white
6 black

SHEET 2
record number access
a thecatwasblue
b blackdogs
c red
d twoblackdogs
e onewhitesock

I need to find every occurance of each cell in the
the 'Access' column of SHEET 1 in the 'Access' column of
SHEET 2.

I then want to copy the entire row of SHEET 1 into SHEET 3
and then copy all the rows that the text appears in
within SHEET 2 into SHEET 3 - bellow the SHEET 1 Copy.

RESULT SHEET 3

record number access
1 red
c red

3 blue
a thecatwasblue

5 white
e onewhitesock

6 black
b blackdogs
d twoblackdogs

Can anyone help me please.
Many Thanks,

Simon