Still not clear

There is no value in C2, I think you are talking about A2

Now where is Sheet4 ? How could I know sheet4 is to be renamed ?