Getting a formula to read multiple worksheet data (same cell range in each sheet)

[Bonzopookie]

Hello,

I have the following formula, and it works well when used. However, I need this formula to calculate the same cell range for multiple worksheets (sheets are labeled "Jan" through "Dec").

Basically, I am entering data each month into blank cells in column C, and I would like my calculations to be tallied up into this formula as I progress each month.

Here is my current formula:

=INDEX(JAN!$C:$C,MATCH(9.999E+307,JAN!$C:$C),1)

I tried to use (unsuccessfully)
=INDEX(JAN:DEC!$C:$C,MATCH(9.999E+307,JAN:DEC!$C:$C),1)

I am not that good with Excel programming, so any help would be much appreciated. Thank you in advance!

[Tony Valko]

This:

=LOOKUP(1E100,JAN!$C:$C)

Will do the exact same thing that this does:

=INDEX(JAN!$C:$C,MATCH(9.999E+307,JAN!$C:$C),1)

However, neither version will work across multiple sheets.