Selecting data from database sheet
 

I have a sheet with a cell that contains a text value. On sheet 2, is an
array contains the value from sheet one in column a, along with more
values...different names. But the name appears much more that once. I want
all the values from column b on sheet 2, that match the value on sheet one,
which appears in column a on sheet two. I need them all together though, at
the top of the sheet. I have been able to get it, but it appears in the
position on sheet one, that it was in sheet 2, which is too many spaces in
between.