keep the serie

I have a count of all the sheets, its looking like that:
=SUM(SATELITE!$C$5+LINDAVISTA!$C$5+DELTA!$C$5+TEZONTLE!$C$5+COAPA!$C$5+INSURGENTES!$C$5+EXPO!$C$5)
i maked a sum, satelite, lindavista its names of the sheets.
the problem its when i take down the information for column 6, excel doesnt auto change the serie, it doesnt change from 5 to 6, and from C to D.
its a big list i cant make it manual, please help me to make the serie automatic.Untitled-3.jpg

That is because you have put dollar symbols in the cell references, so they don't change when you copy the formula elsewhere. Try it like this:

=SUM(SATELITE!C5+LINDAVISTA!C5+DELTA!C5+TEZONTLE!C5+COAPA!C5+INSURGENTES!C5+EXPO!C5)

If SATELITE is your first sheet and EXPO is the last sheet, then you could shorten it to this:

=SUM(SATELITE:EXPO!C5)

which will add all the C5 cells contained within the sheets between Satelite and Expo inclusive.

Hope this helps.

Pete

thanks, thats wat helpfull.