How to get worksheet names to cells?

[rerhart]

I have a workbook that imports several files and creates one worksheet per file--on a regular basis. The file names change occasionally and each worksheet is named after the file name.

What I would like to do next is....create one more manual worksheet in the same workbook, and on that worksheet, in Column A2,A3,4,5, etc... automatically populate each cell in that column with the names of all the other sheets in the workbook....and a bonus would be to have each cell LINK to that other sheet. Can this be done?

[Paul]

In the workbook's Workbook_Open event you can use this code to list the sheet names in A2 going downward:

Please Login or Register  to view this content.