names to following in sequence

1- Fred

2- Joe

3- Mary

4- Susan

5- Larry

each name has a number to represent the order of names

in a column (for eg. A1, if i select Fred from a drop down list (or type it in)), Joe will appear in the cell below and Mary below Joe, and Susan below Mary and Larry below Susan

if i select Susan from the drop down list (in cell A1), I want Larry to appear below Susan and Fred below Larry, and Joe below Fred, and Mary below Joe

the list would wrap itself back to the beginning.

the list of these names on a table could change in size on occasion and would still wrap around

any comments are appreciated