I am unsure if I understand but (ignoring all the page stuff):
If I have in B1 of the summary sheet the text: Sheet2
and in C1 the formula =SUM(INDIRECT("'"&B2&"'!A1:A10"))
that is =SUM(INDIRECT( double-quote singe-quote double-quote &B2&
double-quote sing-quote A1:A10 double-quote))
Then C1 displays the sum of the numbers in A1:A10 of Sheet2
Any help?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Derrick" wrote in message
...
Hello!
Im curious to find out if it's possible to insert the page numbers & sheet
names of other sheets into a table which summarizes all the sheets.
for example:
summary sheet:
page # Sheet Name ...Other Calculated numbers...
1 sheet1 ###
2-3 sheet2 ###
4 sheet3 ###
5-10 sheet4 ###
whe sheet1 will print out on 1 page, sheet2 on 2 pages, etc. -
depending
on page breaks
hopefully this won't include me manually inserting any numbers or names.
Any help?
Thanks,