Guess you could have formulas referring to range of worksheets in your
original sheets (Sheets 1-4 referred in your post). Try removing the range of
worksheet reference in formulas and change it to specific sheets and
cells(For eg: Sum(Sheet1:Sheet4 A1) used for range of sheets instead try
Sheet1A1+Sheet2A2+...)

"Doug T" wrote:

I'll do my best to make this short.
I have workbook with a number of worksheets that interact with each other
through links. The idea is that if I change the information contained in a
cell on one sheet, the linked info on another sheet will also change. I set
this up using Paste Special/Paste Link.
So, to explain the problem, say I have 4 sheets of data. I create a 5th
sheet by copying a template I have set up, and then Paste Special/Paste Link
data from any or all of the original 4 to the new 5th sheet. Everything works
fine on the 5th sheet as long as I don't move it. Changes I make in the
linked sheets are reflected on the 5th sheet as intended. Then, when I drag
the new sheet (the tab) to another location in the workbook, say between 2
and 3, the links to the new sheet quit working and some of the others quit as
well. I have tried this on 3 different computers and the result is the same.
Any ideas??