I am having problem with work sheet naming from a cell I know this has
been posted before by other people but I can't get it to work i copy
and paste what they say and i just can't get it to work

On sheet 1 cell c8 I want sheet 2 tab name Tom or a number
On sheet 1 cell c9 I want sheet 3 tab name Ray or a number