Hi,

I would like to copy the Sheetnames from my workbook into a summary sheet.

eg.
I have 5 sheets in my workbook:
Sheet1(PageA)
Sheet3((PageB)
Sheet9(PageC)
Sheet111(PageD)
Sheet7(SummarySheet)

Would it be possible to copy the names of my sheets into the "SummarySheet" into a 2-column table? Where the first column would keep: Sheet1, Sheet3, Sheet9, Sheet111 and the 2nd column: PageA, PageB, PageC, PageD .

Ultimately I would like to test whether Sheet names have been changed by my users and if so, to rename them to the original names when the workbook closes.

Hope some wizard can help me out!
Sige