can i enter a formula on on 1 worksheet, and then refference it on the 2nd,
as indirect(), with the intentions of having it actually calculate the
refferencing worksheet?

ex:
sheet1, A9 contains: = sum(A1:A8)
sheet2, F30 contains: =indirect('sheet1'!A9) 'with the intention of the sum
of cells A1:A8 ON SHEET2 being displayed in sheet2, F30

thanks in advance,
mark