Copying Cell Titles

Hi,
I have a list of worksheet tab titles at the bottom of my workbook which i wish to list on a main summary sheet.

I need to have these worksheet titles listed down in separate cells.

Is this possible?

Thanks

very easy with a macro
do you only want a list of sheet names, or do you also want to hyperlink the the sheets?

I only need a list of sheet names however could i also be greedy and ask how to do the hyperlink option aswell?

Hi
this lists the titles, the hyperlinks will be with you shortly!

Please Login or Register  to view this content.

here's one with hyperlinks:

Please Login or Register  to view this content.

Thank you very much

I am very grateful