Searching for text in a row and producing a list

I have a table in A1:BI8 on sheet1.

I am wanting to, on sheet2, search row 5 (from the table on sheet1) for specific text (eg "1D1") and return the corresponding information in row 1 (eg a name).

As there will be multiple matches of specific text ("1D1") can this return all of these matches in one cell or insert a new row below and insert the next name.

Thank you for any help.
Regards, Andy!