Assuming you don't want to specify the name explicitly, but use a formula to
derive it:
There is no specific support for this. If you sheets have some type of
sequence inherent in the name, you could parse out the sequence of the
current sheet using Cells("filename",A1) as a start, then subtract 1 from
that and build the previous sheet name.

--
Regards,
Tom Ogilvy

"Daniel Lidström" wrote in message
...
Hi,

how do I reference a cell (say f39) in the previous worksheet? I want to
accumulate values from each worksheet to the next one. Something like
=$previous_sheet$f39+sum(f1:f38)
Thanks!
--

Daniel