Cell Reference Help

[Rich9016]

hey guys, please help!

i have a cell that sums another particular cell among several worksheets. in other words, my cell will sum worksheet1:worksheet2!A1.

now lets say i wanna move the data in A1 somewhere else. if i move it, is there a way to have my original cell account for the change. so if i move the data in A1 to B1, is there a way i don't have to go back and redo all my formulas so i end up with worksheet1:worksheet2!B1?

Rich

[Rich9016]

bump......