Comparing rows in two sheets

Hi.

I have two sheets with alot of entries that I want to compare and get the results in a third sheet. So what I need is a macro that can do this.
Its a little bit complicated but I'll try my best to explain.

I have two sheets:
Sheet A contains the list of entries that I want to compare with.
Sheet B contains the master list or database if you will.

What I want to do is to take the first row in Sheet A, copy it to a third sheet named C. Then compare the value in column B in that row with all column B values in Sheet B (the database). If a match is found, the row that contains the cell which matched is copied and pasted under the original row from Sheet A.

So in Sheet C it would look something like this:

Row 1, Sheet A: Type LAA
match 1 in sheet B
match 2 in sheet B
match 3 in sheet B
etc..

Row 2, Sheet A, Type LA2
match 1 in sheet B
match 2 in sheet B
etc.


Thanks for any help on this. Its been driving me crazy

EDIT: I have now made a test xl file that hopefully is of help! See attachment.