Setting up separate tables for each work is a far from optimum database design. You really need a table where you have one record for each employee linked to another table where shift that one person works is a single record linked to their record in the first table.
Thanks for the reply. I kinda knew that, but I didn't want to have to import the data I already had in the file. Anyway, I did as mentioned-created two table and created the relationship. Screenshot attached. Still needs some work, but the basics of a working file the way I want is there.