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

I am looking to do almost the exact same thing and the best I've been able to come up with is a custom list and auto-fill. Not too great at the Excel thing. I'll keep looking and if I find anything I'll pass it along. Maybe some Excel Guru will help us out!

Pl see attached file with macro.
Before and after table given.