Automatically assign workflow in SharePoint?

Question

I am trying to assign individual list items to a queue of people based on rotation.

Here, essentially, I'm trying to do:

Names: Bob With Joe B Emily R

In a SharePoint list, if any user (outside of these three people or including these three people) adds an item to the list, a warning will be sent to bob and only bob, also a cell in this line of the list I hope will be filled with the name of Bob assigned to this element. The same thing happens if a new list item is added, but it will be assigned to Joe, then Emily, and then back to bob, etc.

Is there a way to do this: workflow settings or some other way?