Creating a list of people who meet certain criteria in a large spreadsheet

[Murrace]

I was wondering if this can even be done in excel. I need to create a list of workers who are available or possibly available to work from master schedule. The list should include their name, job title and start and end of availability. Availability is determined according to a color (could be changed to a letter or number) and date on the master sheet.