Is it possible to search through non-distinctive data using VBA?

For example:

Worksheet "A"

Column A
A1
A2
A3
A4
A5

Worksheet "B":
Column A | Column B | Column C
1/1/2014 | A1 | COMPLETE
1/2/2014 | A2 | STARTED
1/3/2014 | A3 | STARTED
1/4/2014 | A4 | COMPLETE
1/5/2014 | A3 | COMPLETE

I want to be able to search through Worksheet "B" for every value listed in Worksheet "A". If the value is found, I want the information listed in each row from Worksheet "B" into Worksheet "C". In this case, I should have 2 rows of information for "A1". I haven't started on the code yet but I am getting lost in the logic with creating a loop to continue to search for "A1" until all values have been found, copied, and pasted, and then search for A2, A3.. etc.


Is this possible to do?

Thanks.