hi,

i would like to know how i can havea summary sheet which takes all the
values from cell C2 frmo each sheet and add them up on the summary sheet.

the problem is that people can add sheets dynamically like there could be
anywhere from 1 to 10 sheets. but the sheet names can be like sheet1,
sheet2, etc.

i would like for the cell on the summary sheet to be something like ...
=sheet1!C2 + sheet2!C2 and so forth.

but i want the formula to go all the way up to indlue cells from sheet10. i
would like to know how i can change this formula dynamically so that it
reflects adding up cell C2 from 2 sheets, etc. all the way up to 10 sheets.

thanks in advance,
geebee