I am sorry for not being clear, it is in the named ranges that the worksheets
names are being inserted. Like I have a named range called PCSize. it should
be looking at one other named range called PCRace. However when I look at
the named range formula it instead insterts 'Sheet back'! before the named
range it is to be looking at when I try and remove the extra stuff it doesn't
take, also the named ranges from some sheets aren't able to be used in some
others.

If you know when you copy a sheet that has named ranges to another book, it
asks if you want to create the named range or use a link. I think I may have
told it to use the link on accident and now it won't look internally within
the document for any data on some sheets.

"SVC" wrote:

Have you checked the ranges via Insert Name Define? It may be that the
ranges being pulled are referencing the old workbook, and you might need to
delete the range names and reinsert them.