two or mor list in a sheet

[layla]

Hi,
I have three list s in a sheet ,how can I know how many they are and
the name of each(or a ponter to each)
Thanks

 

[Klemen25]

I presume you want to know this IF you have more sheets than three?
One way would be to use a macro to create a table of contents. There
are many on the internet, so after the macro creates the table you can
mark all cells with the names of sheets and use excel automatical
count function in the bottom left corner. Some macros also create
links to these sheets...