How to sum the same cell across sheets

[lukerees83]

If I have a spreadsheet with 12 tabs/sheets on it, one for each month of the year.

Each S5 cell per sheet represents a certain count-up of figures for the month, but I need a formula that adds up every S5 cell across the sheets and places therefore gives me a value for the year.

Can this be done?

 

[T. Valko]

If I have a spreadsheet with 12 tabs/sheets on it, one for each month of the year.

Each S5 cell per sheet represents a certain count-up of figures for the month, but I need a formula that adds up every S5 cell across the sheets and places therefore gives me a value for the year.

Can this be done?

If the sheet names are the month names...

=SUM(Jan:Dec!S5)

=SUM(January:December!S5)