Dear @Marta_Oliveira,
I recommend you create a button, that potential through automation, creates for every day for employee a new row, where the location can be assigned. (you might need also need to consider when this employee has any form of leave, like sick leave, maternity leave)
The be able to generate this you need to include the “formula map” formula in your button to iterate for each employee a new row.
In the below post I have created a solution for interview questions that repeat for each interview session.
I have the feeling that this will get you on track. Start small in a copy doc with very limited info to get it working, when you see how it goes, adding on is a “piece of 
”