Need a function like =formula('Sheet1'!A3) - does it exist?

[AdamParker]

Hello,
I have many detailed worksheets that contain forecasts and that roll up into a summary worksheet... as time progresses I have to adjust my "year to date actuals" formula on all my sheets (ie: sum(april to june), then next month sum(april to july)) - .. I currently do this manually on all of my worksheets and was just wondering if there was a way of doing this on my summary sheet and then somehow having the detail worksheets use the same formula that the summary worksheet is using... sort of like =formula('Sheet1'!A3)

I hope this is coherent.. thanks for any info you can provide.

Adam


-----
Solved comments:
Thanks for your suggestion... I haven't thought of using this and it was remarkably simple. I've just put in a sumif to include those months that contain "Actual" and then as I update the numbers from forecast to actual, the YTD actuals update themselves

Genius!!
Thanks a lot!

[romperstomper]

Depending on your workbook layout, there may be many better ways of doing what you need, such as SUMIF formulas. Any chance of seeing a sample sheet? (dummy data is fine as long as the layout is accurate)