OK kids, there's a five spot for whoever can answer this first (payable in Nashville): I have an Excel document with several sheets. Right now one of the sheets points to an earlier one; i.e. there are lots of cells in it that say stuff like "'May budget'!C6".
Now I want to copy the entire sheet into a different version of this same document. I.e. the sheets and their names etc. are all identical. The problem is, when I copy and paste the sheet from my version onto the "same" sheet in the other document, Excel quite understandably is still linking those cells to the May budget sheet in the first document. I.e. I want to paste it in such that the cells point to the 'May budget'! in the same file.