Filtering Column Cells And Maintaining Other Column Values

I have a spreadsheet with multiple columns:

Column B - Host Contact
Column C - Company Name
Column D - Attendees
Column E - Contractor Position

Column B will have anywhere from 1 to 10 names.
Column C will have 1 -2 names.
Column D will have anywhere from 1 to 10 names.
Column E will correlate with column D.

This list will go to multiple people who will want to filter column B for their name. When they filter their name, they should see all values in columns C, D and E.

When I try to filter this spreadsheet by a persons name in Column B, it only shows me the first value in columns C, D and E.

One of the attached pictures shows a mock-up of the unsorted list, the other shows the sorted list.

Sorted Format.PNGUnsorted Format.PNG