Create a "sheet sandwich".

Insert a new sheet immediately to the left of the first sheet you want to
include and name this new sheet First. Insert a new sheet immediately to the
right of the last sheet you want to include and name this new sheet Last.

Then use this formula:

=Min(First:Last!C51)

When you insert new sheets just move them between the First sheet and the
Last sheet.

--
Biff
Microsoft Excel MVP


"Robin" wrote in message
...
What is the formula or instruction that allows summary data from
Worksheet1:Worksheet? to automatically update when a new worksheet is
added.
Example: the Summary sheet has the following formula
=Min(Worksheet1:Worksheet5!C51), then another worksheet is inserted
(Worksheet6). Is there a way to have Excel automatically update that
formula
to become =Min(Worksheet1:Worksheet6!C51)? Would you do that with a Macro
and how could this be accomplished ?