I have a spreadsheet that I distribute to up to 4 people
in my office (depending on what account we are on) These
recipients fill out data in specific order that is based
on the prior persons info input.

To start the chain I have inserted a userform that lets me
(The host and also the first person to input information)
set up all the users for that day. The names get inserted
into cells D11-G11. With another cell (C2) set up to say
in very bold lettering whose turn it is to enter the next
Information.

What I want to do is instead of having the users change
this cell every time they are done inserting their info
and before they send it to the next person for input, is
to have this done automatically by cycling through the
list of names in order until all info is entered and then
the sheet will come back to the beginning (Me). Then I
start the new series of info inputting until we have all
the data filled in, this takes about 6 rounds before it is
complete.

The spreadsheet is set up with a macro button that
calculates the final info and sends an e-mail to a
dedicated server for backup filing. When this macro is
preformed I want to cycle the name at that point and e-
mail the saved file to the next user.

Is this possible?

TIA for any insight.
Pete