I am not too sure what a hyperlink is but I just wanted to make a list of all
the worksheet names. This in in order to make a matrix with names of
different products in top row, and then the value assigned to each product in
each worksheet. Does that make any sense?

Thanks.

"Dave Peterson" wrote:

> You want a worksheet that uses hyperlinks that point at those other sheets?
>
> David McRitchie has a macro that will build that table of contents worksheet:
> http://www.mvps.org/dmcritchie/excel/buildtoc.htm
>
> confusedexceler wrote:
> >
> > I am trying to create a function that will list all of my worksheet names,
> > one per row, on a summary page. I cannot seem to be able to link the title of
> > the worksheets to anything? Please help. If this requires some sort of macro,
> > please be very precise since i have no clue how to use VB. Thanks
>
> --
>
> Dave Peterson
>