You can use VBA to change the sheet name to match a particular cell's value. You can use a formula to extract a sheet's name into the cell. Who's the leader and who's the follower? Does the sheet name determine the cell's contents? Or does the cell's contents determine the sheet's name?