Were you able to figure this out? I am looking to do the same thing...i have
30 sheets that are all templates with different information on each sheet but
want to compare on a total sheet the information from each tab same cell...

"Ray Stubblefield" wrote:

The situation is more complex. I am trying to create a summary sheet that
looks up results contained in a specific cell across approx. 100 sheets. I
need to lookup based on a specific reference number that is contained on both
sheets.

I am currently working on the TREED function using either VLOOKUP or
INDEX,MATCH formulas.

"Don Guillett" wrote:

this maybe.
=sum(sheet1:sheet21!a1)

--
Don Guillett
SalesAid Software

"Ray Stubblefield" wrote in
message ...
I have a summary sheet where I want to lookup a number that is referenced
the
same on multiple sheets. I desire to have the summary look to particular
tab
names and return the amount in that particular cell.
Any ideas please?