Hi Eric

I did say
Would a VBA solution be acceptable, if I cannot figure out a formula
solution?

So, you don't want a VBA solution - fine.
I am finding it difficult to visualize your workbook, hence the request to
see a copy to determine whether I can suggest a different formula approach.
The offer still stands - if you want to take it up.
--
Regards
Roger Govier

"Eric" wrote in message
...
No thanks Roger, that's not what I was looking for. I have a solution
that
does the job albeit inelegantly: A single formula in each cell on the
Totals
sheet with a string of all 13 expressions Summing each of the 13
File:Tab:Cell references. What I was looking for was a Function that
would
cycle through the creation of each expression, allowing the incrementing
of
the Sector number in the file name by 1 in each step, and adding the
result
of each expression together. This would be a much more satisfying way of
solving this problem, but I have so far not found the means to do it.
Undoubtedly this could be done in a macro using VB, but that would lose
the
transparency I want to maintain, in a spreadsheet that will be passed on
to
others. Also, if the erector set is going to be built, I want the
satisfaction of building it myself.
Thanks,
Eric