Populating Cells Based On Multiple Criteria

Good Morning All,

I'm trying to create a worker schedule based upon availability in excel and was wondering if you all could assist me. I've attached the current document I'm working on for your reference.

So there Six Employees: Rick, Kelly, Sharice, Robert, William, and Mary. Given their provided availability, I would like the "Availability" sheet to look like the "Availability Desired" sheet. Ignore the formulas in each of the "Employees" sheets - I had just made the "Availability Desired" Sheet to try to see if I could reverse it somehow... I wasn't able to...

Any information/guidance you could provide me would be greatly appreciated.

Cheers,

LA

EDIT: I'm not using Excel for Mac currently. FYI.