Looking up data to automatically fill in summary table

I have inherited a spreadsheet that needs to be filled out with daily/weekly rotation of where employees will be working. Basically I manually fill in what jobs people are doing on a daily basis for the week. Then below is a summary of what line they will be on/or what particular job they will be doing. To do this, I use a drop down list to select the code relevant for the details. This can be very time consuming. This can be amended quite a few times depending on circumstances.

Is there anyway that this can be done automatically, so that it will pick up the details for each name entered on the sheet and the appropriate code for where they are working for each day? And then any blank cells remaining, I can then just add the appropriate code for them, eg day off, holiday, etc?

I have attached a master sheet of how it looks at the beginning of the week and a filled in sheet as examples of the data. In the filled in sheet, I have added notes of what jobs come under which codes, so as to try and make it easier to explain what I'm trying to do.
Hopefully it will make sense, what I'm trying to achieve.

Any advice on this would be fantastic.