This might help, copied down,

=INDIRECT(A1&"!$C$2")

Vaya con Dios,
Chuck, CABGx3




"LdyWldKat" wrote:

I have a formula on each worksheet that gives me a count number that I need
to show on my index sheet. That formula is on every tab at C2. I need each
tabs number in C2 to show up next to the corresponding tab name on the index
sheet. The index sheet tab names are hyperlinked. I can change that if I
need too.

Thank you,
Kat