Vlookup question

I am using vlookups but come across an issue where if multiple records exist it only pulls through one of the values. I have had a look around and found people talking about this however I cannot seem to get it working still.

Example below

[Source sheet1]
A B C
Amy blue Tshirt
David green Tshirt
David red Trousers
John yellow Tshirt

If I do a classic vlookup against the above and ask to return the values in B I will only get green returning for David. I have below shown the target sheet where I am collating the data form the above

[Summary Sheet]
A B C
Amy Tshirt =VLOOKUP(A1,SourceSheet1!A:C,2,FALSE) - Should return Blue - WORKS
David Tshirt =VLOOKUP(A2,SourceSheet1!A:C,2,FALSE) - Should return Green - WORKS
David Trousers =VLOOKUP(A3,SourceSheet1!A:C,2,FALSE) - Should return Red - DOES NOT WORK
John Tshirt =VLOOKUP(A4,SourceSheet1!A:C,2,FALSE) - Should return Yellow - WORKS

I will need to somehow put logic in to include the C column containing the 2 different types (Tshirt, Trousers). I may need to put extra types of garments into the column such as shoes or socks. This means I will need this to be dynamic enough to understand if there is a person with the same name but with multiple garments in the source sheet it can differentiate it. the spreadsheet i am using to collate this will have multiple entries for each name with the expected garment already in as in the second table (Summary Sheet)


Any help appreciated

Thanks for the suggestions. I will give some of these a go.