Use Drop Downs to Populate Other Drop Downs

Hello Everyone,

I have been looking through the web and this forum for some time but still can't grasp what it is I need to do.

What I am trying to do is have one drop down that will auto populate other drop downs. I have in Column A a list of assignments and in Column B drop down lists with the employee's name. At the bottom of the sheet I have one more drop down list that contains the weekdays. I would like to figure out how to change the bottom weekday list from day to day and have that auto populate who goes to what assignment.

I would like to keep the drop downs for the Employee's name instead of a VLookup formula but don't know how. I have looked through the http://www.contextures.com/xldataval02.html page but I can't figure out how to link what it is teaching to what I need to do.

I attached a little sheet that shows my idea but no real formulas.

Thanks so much in advance

Fbombs