[Dave Breitenbach]

I'm trying to consolidate cell "u1" across multiple tabs using the SUM
function.
The following works for me:

=SUM('tab 1:tab 2'!U1) [resulting in 2 if both u1's are 1]

I know the name of the first tab but the name of the last tab I want to be
determined using the indirect function which will refer to a cell which has
the name of the last tab in it. I've tried the following:

=SUM(INDIRECT("'tab 1:"&$T$5&"'!U1"))

where t5 equals "tab 2", but I get the #REF! error.

Any help wuold be greatly appreciated.

tia,
Dave