List Of Sheet Names & Create Hotlinks for each one

[Guest]

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.

 

[Frank Kabel]

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

 

[Guest]

Frank,

Thank you for your timely response. The links you showed me are extremely
helpful and I have completed my tasks with a couple of minor problems witch I
will try to figure out today.