Take a look he

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


In article ,
index wrote:

Hi there,

Is there anyway I can user a macro to create an index of all the
worksheets in a workbook?

Ideally it'll create a worksheet at the front of my book listing the
names of the worksheets which follow in the same book?

Can anyone help please?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/