If I have a list of people in the A column, is there a way for the worksheet
tabs reflect those names automatically?

Example:

Sheet1:
A1: Joe
A2: Bob
A3: Bill

Sheet2 renames to what is in A1, or Joe
Sheet3 renames to what is in A2, or Bob
Sheet4 renames to what is in A3, or Bill

Then I rename A1 to Albert, and Sheet2 or the €œJoe€� sheet automatically
becomes Albert now. Thanks!