Excel totaling from sub-worksheets

I have 12 worksheets, one for each month.

I want to have a YTD page that has cells that link to T0TALS of the same cell in the monthly sheets.

 

Here is an example of the formula
=SUM(Sheet1!A4+Sheet2!A4+Sheet3!A4)
To get this formula, click in the cell in the worksheet where you want the formula to appear. Type =sum(
Then click on the first worksheet you want to include in the formula. Then click on the cell that has the total. Then type a plus sign. Do this for every worksheet you want to include in the formula. At the end type )

 

Thanks. That's just the result I got but the hard way by taking a first line of sheet1!A2, putting it into a text ecitor and copying that word 12 times, and then replacing each Sheet designation with 3,4,5,6,7,8 etc. The clicking is easier !

 

Your welcome