searching for a cell val & returning all vals in col B of all rows the cell is found

[fullymooned]

search entire sheet for all rows that contain the cell value that is in
col B. Return the cell values of column C, D, E of all rows that
contain the cell value being searched.

A function or a macro would do

Thanks