Not really well without code, but it you put a formula somewhere in each
sheet that gets the prior sheets name and the location of the sum, you can
reference the cell with an indirect. Something like this
=MID(CELL("filename",Sheet1!A1),FIND("]",CELL("filename",A1))+1,256)&"!B2"
Sheet1 being the prior sheet and B2 containing the value
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Rob" wrote:

I wish to create a sum formula that references the previous sheet in a
multiple worksheet workbook. I would then like to copy the formula to the
next sheet and maintain the relative refrence to the new previous sheet. Is
it possible to do this without having to change the reference in each sheet?