I'd use this kind of technique:

Insert a new worksheet to the far right (name it Finish) and one to the far left
(name it Start).

Then put the summary worksheet to the right or left of this "sandwich" of
worksheets.

=sum('start:finish'!a12)

And if you want to play "what if" games, you can drag any of those worksheets
outside that sandwich to see how the sum changes.

Gymclass14 wrote:

I am trying to make a function that will total information from other
worksheets. The information will come from a single cell in each worksheet.
Example: I need total from cell A12 from each worksheet to be totaled on a
different worksheet. Its making me go crazy tring to figure this out.
Thanks in advance for the help.

--

Dave Peterson