Hello, I have a workbook with approx 35 sheets, the first sheet is
named "TOC". I am trying to create a table of worksheets in this TOC
sheet. In colum A i am entering the relative position of the sheet,
that is first sheet, second sheet and the next colum B, i am entring
the worksheet name against the colum A, its position, to give me a
table of worksheet name in order of their appreance.THe challenge is
that I can get the worksheet name by running the macro, but I am unable
to create thie positions 1,2 3 4 if the worksheet position is
changed.SO I end up geting the name of worksheets first and then
updating the numeric sequence. Can there be a VBA code to do this.

Any help is geratly appreciated.

Vivek