Oops! Read the post wrong. Apologies for any harm.

I tried this on a small sample and it seemed to work. Highlight the column
that you want to change and go to EditReplace. Replace 'Sheet 2004' with
'Sheet 2005'. In my test I selected "Replace all" and it only replce those
in highlighted column.

HTH
cwilson