I work with some weekly worksheets and I figured my work was getting
extremely repetitive. I've managed to get around most of the repetition
for all except for one: my dreaded weekly summary. In this, I add values
from all other 7 worksheets. I can do this perfectly well, but I can't
use the same formulas in other files, even if the formulas would be
perfectly identical, because the names of the worksheets are
different.

Is there a way to add the values by only referring to the number of the
sheet instead of referring to it by name? Note that I use these formulas
in literally at least a thousand cells, so Macros might not be a good
idea..


--
ArenaNinja
------------------------------------------------------------------------
ArenaNinja's Profile: http://www.excelforum.com/member.php...o&userid=33624
View this thread: http://www.excelforum.com/showthread...hreadid=547675