Create a rotating Schedule

Hello all,
I know the basic's of excel but I am not that great with advanced formulas. I need help with a work schedule. I create a work schedule every week for 16 people that all have different days off. I want to create a schedule that will rotate the names thru the positions such as move them up one spot but take into account their days off. I have included a copy of the schedule I am working with. In green is the area I need the people to rotate thru, in blue are their days off. Please help

Thanks in advance