Calendar/Schedule

Greetings,

I am trying to manage a monthly schedule that shows me who is working on which unit at what time based on a given day based on some pull down menus/criteria.
I've attached a general excel sheet that shows what I am looking to do. The employee/unit list is quite extensive and has been shortened for sample purposes.
There are various alphanumeric characters on the employee list that represent which shift the person works, vacation, and some other things that I have not included.

How do I generate "the list"?

Thanks,
Spart