Excel Named Cells

[HeatherMichelle]

I have a workbook with 3 worksheets that all contain named cells. I use those cells in a roll up page; ie: in cell B4 I have =ArlingtonSMFTE, which references a cell on the third worksheet... I had to move the worksheets to a seperate workbook and then combined them back later. Now when I go to my roll up sheet to use the =namedcell it brings up an update values box like I should select a file???
I really can't imagine creating all new named cells!! Any help is greatly appreciated!