Rolling roster

Hi

I've been working on a rolling weekly roster for work and was wondering if there was a formula were when the name at the bottom of the roster would automatically move to the top.

I've attached a test roster so you may get an idea as to what i'm talking about.

On my roster person 53 would up to position 1 the following week.

Thanks in advance.

Hagar