Hi
see:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"SPYREN" schrieb im Newsbeitrag
...
Greetings,

I have a Workbook named STPData which contains 10-100 sheets Named
STP with
Date and Time stamp such as (STP 10-25-04-09-55).
Is there a way to create a new Sheet named STPMain that automatically
lists
all of the sheets and create a Hotlink to each one of them from the
STPMain?.
The naming of the sheets can be modified to meet any scheme that may
be
necessary to accomplish this and if possible to list the latest dates
first.
In addition, if I can create a second sheet "STP Data Compare" that
will
create column headers for each of the above sheets and copy below the
header
the data from column B from each of the Sheets?.

Thank you in advance for your input.