This works:

With the number being in cell A1 on each sheet.

=LARGE(Sheet1:Sheet10!A$1,ROWS(A$1:A1))

Copy down for a total of 5 cells.

--
Biff
Microsoft Excel MVP


"Steve Haack" wrote in message
...
Let's say I have 10 worksheets which have the results of 10 games (or
competitions). On a summary sheet, I want to find the 5 largest scores
from
the competitions. LARGE assumes that the array I want to search is
contiguous
(all on the same sheet). Is there a way to tell it to look at each of the
10
sheets and find the 5 largest scores? Perhaps its just a syntax thing and
I'm
just not sure who to indicate what I need.

Thanks,
Steve