Does this help? (Bottom of page)

http://www.nickhodge.co.uk/vba/codeexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"LdyWldKat" wrote in message
...
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