Ability to paste the next value in a column each time I run the macro

Hello,

I have a list of names in a column, for example:

Anna
Benjamin
Corey
Danielle
Emma

I need a button to tell me who's next on the list.
Essentially, when I press the button the first time, my ActiveCell value will be "Anna". The next time I press the button, my ActiveCell value will be "Benjamin" and so on, eventually going back to begin with "Anna".

Any ideas?

Thanks,
Mo

Thanks for your help.

I'll try and incorporate this into the macro I've used.

Cheers,
Mo