Rotation Assigment to New Clients

INPUT PLEASE

I am trying to set up a spread sheet in 2002 that allows a new client to have an intake worker and then a primary worker assigned to their case based on a rotation.

I have a list and assigned numbers to each category, but don't know where to go from here. I have reviewed multiple threads that show various ways to look up or code in how to do this but haven't been able to apply it to my sheet.

Is it possible to have a worker removed from rotation or skipped? or added if a new employee is hired?