Yes, if you have deleted the old lookup sheet, then the named ranges
which were on it will now have #REF in the Refers To box if you do
Insert | Name | Define. You will need to delete these old names and
re-instate them for the new lookup sheet.

Hope this helps.

Pete