EDIT - SOLVED

I have to make a rotation schedule for coworkers for the next year. Some coworkers have standard days off and I do not want to schedule them on those days.

This is the manual outcome I would like to get. Example: Consultant A does not work on mondays, so I do not want Consultant A to be added to the schedule on a monday. I then want consultant B to be added to the schedule as a fill-up. Consultant A would be next in line on a tuesday etc. Next would be consultant C but consultant C does not work on wednesdays. Therefore, we need to take consultant D for wednesday and consultant C on a thursday, and so on. When we are at the last consultant of the F colomn, it needs to start again at consultant A.

I have tried all kinds of formulas, like if statements and arrayformula. But there is no way that I know of to loop through the F colomn just with formulas. I am not sure if this is at all clear what I want to achieve here, i am stuck