As much as Excel looks like a 3D spreadsheet, its actual 3D functionality is
very limited, especially if you are not comfortable with VBA solutions.
Excel is really good at working with data tables, though, and there is
really no reason why you could not do exactly what you want with just one
worksheet, and then using data filters or pivot tables to get the data of
interest. You might be able to consolidate 100 ranges into a pivot table,
but I have never tried it with more than 2 sheets...

If you were to take all the sheets and copy your data into one, it would be
an incredibly simple task. IF you would like to try to merge all your data
to use a pivot table, take a look he

http://www.rondebruin.nl/copy2.htm


As it is, you might be able to do it if you want to use a
User-Defined-Function and if your individual sheets are structure
identically. If so, then post back.

HTH,
Bernie
MS Excel MVP


"aglen" wrote in message
...
I am trying to return the name of a person who worked the most hours in my
volunteer table. The columns include the person's name, date worked,
number
of hours per shift and total hours worked. There are 100+ people that
each
have their own worksheet. I would like to use a lookup to return the name
of
the person with the most hours. How would I do this? I tried grouping the
sheets and referencing the ranges I want to use.

Thanks.