I have a workbook with X number of worksheets in it, what I am trying to do
is have the code scroll thru the each of the sheets get the name and place
it on an index sheet as a link to that particular worksheet, the user can
then click on one of the names and be taken directly to the worksheet.

Thanks