Create 2 dummy sheets then insert any new sheets in-between these 2 sheets

=SUM(First:Last!A3)


--
Regards,

Peo Sjoblom



"JakeShipley2008" wrote in
message ...
Hi, I am trying to find out if there is a function I can use in a summary
sheet that will pull data from an unknown sheet name. In other words I
would
like to have the summary sheet in place and as I add new worksheets it
will
pull data from them without having to go back and redo the formula.
--
Jake