Searching Concatenated Cells On A Sheet

Concatenated cells. My issue is how do i search through a sheet with cell values that have been concatenated?

Lets take an example:

I would like to search for a string call sales in sheet1 which would display all the employees and schedules for that department (do note that employees can be part of not just one department). but my cell formatting is as follows:

Sheet 2, Column 1
Employee name

E.g. Row 2 Employee1

Sheet 2, Column 2
Department (cells concatenated)

E.g. Row 2 Sales, Marketing (Concatenated Cell)

Sheet 2, Column 3
Work schedule

E.g. Row 2 8 AM to 5 PM

So when you search for sales, it will display employee1 and work schedule.