getting results on separate tabs

[josephone baker]

Hello,
I have an Excel spreadsheet that has several tabs for diff categories. on
one tab, i have set up a simple sum formula to add up current expenditures
and totals (orig. budget balance and also funds available). so, i would like
to do a sort of "cover page" for all the tabs in this Excel file, and "link"
the automatic sums that appear on one tab to this front page tab. Is there a
way to copy a formula that will automatically update on this separate page to
correspond to the other page /info added to that page?

Please help!
Maria

 

[FSt1]

hi
on your cover page, put a forumal like this...
=sheet2!A1
this will bring the contents of the cell A1 on sheet 2 to the cover sheet.
you can also use sheet names in the formula. you will need a formula for
each cell total on the other sheets.
adjust your your data.

Regards
FSt1