Trying to create a weekly work schedule. Created a table with dropdown menu. How can I reference this table to a separate table that the value has already been chosen?

Hello,

I created a weekly table with a list of employee names. I also created a dropdown menu for each field of all the job types to select from.

I am trying to reference this table into a different table with all the job types on 1 column so I know that it has been chosen on any given day. I was thinking it can populate with a '1'

Bonus if the same job is chosen again, then it can populate a '2'. If this is not possible, then perhaps, using different colours?

I will add a photo to give you an idea of what I'm trying to do. Thanks.