Hi Simon,
I can't find a previous request in the last 5 days from the same author
as used in the thread, so don't know what the previous answers were.
You need a macro.

Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Build TOC Another Approach
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Simon G" wrote in message ...
Hi Norman
Sorry, I do not understand where I can get a solution for...
How do I get a list of all of the worksheets within a workbook in a single
'summary' worksheet. I have about 300 worksheets and do not want to link
each one, one at a time.
Many thanks
Simon

"Norman Jones" wrote:

Hi Tthe,

See responses to your earlier post(s).

---
Regards,
Norman



"tthe" wrote in message
...
how can i list all the worksheet names in a master sheet?
is there a formula? an easy way??