aside from the doing this manually each time i either create a list or new sheets is there a formula for what i am trying to accomplish?
i have a workbook with lets say 4 worksheets.
work sheet 1 has my list of the other sheets names so we'll call it index.
Index
sheet-A
sheet-B
sheet-C...