You can create a table of contents for an XL workbook with a macro.
See here for more info: http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Dave

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Brent" wrote:

I have read through a lot of the suggestions and it seems most are for having
an active worksheet name in a cell. I would like to have lets say 24 cells
on ONE worksheet give me the names of the following 24 worksheets or the
other way around where the 24 worksheet names reflect the 24 cells on the
separate worksheet. Any suggestions?