How to use the same formula on different sheets in a workbook?

[anoble1]

I have a workbook with about 12 tabs. Each tab has data from 2010 - 2015 which has money totals that update depending on what month it is.
Right now, every first of the month I have to go in each column year and change the formula to grab the new month. Such as: =SUM(J4:R4) is 2010 January - September
I go in there and change the formula to =SUM(J4:S4) and so on and so on year by year and tab by tab. All tabs are the same range of data.

Is there a way to create another tab and just update those year values and have the other sheets point to that to get the update?

[TMS]

Probably. Post a sample workbook.

Regards, TMS

[José Augusto]

Try this
=SUM('First:Last'!J4:R4)
where First is the caption of first tab and Last the caption of last tab