LdyWldKat schrieb:

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

If you construct your index sheet manually you can just reference the
count field of each referenced tab sheet next to the hyperlink,
something like

=Sheet2!C2

If that's not your problem, give an example.

Regards,

Hans