Thank you but I probably didn't make myself clear.
Inside a spreadsheet called "survey", I have a worksheet called "participants"; In it, I have a list of names. For instance, participant 1 is joe smith.
I have another worksheet (inside "survey") named "participant 1".
If I change the name of participant 1 from Joe Smith to Dave Jones, I would like the worksheet named "participant 1" to be changed to Dave Jones.
Does this make sense?