I have seen several close solutions...here is what I am trying to do:

Sheet "HOME" has a range from e9:e24 When user enters in cell e9 that entry
is linked to cell c6 on another sheet. I want that sheet to be renamed to
that entry. I used anothers code to have it work, however, I need to edit
cell c6, then hit enter and it will change. I need to have it automatically
change the sheet name. I.E. User is on sheet "HOME", they enter in cell E9
and they see the associated sheet name change. Thanks in advance!