display worksheet name in a cell

Sep 22, 2009
Reaction score

I am creating a summary sheet in a workbook. I need to display all the worksheet/tab names in column A starting with cell A2. I am able to display the current sheet in a single cell using one formula, but i need a formula that i can drag down the column and it will list all the worksheets in the workbook. Each worksheet is the first initial and last name of employees. In addition, the sheets listed in column A will act as a index for pulling data. I have not been able to figure this out. My experience in excel does not go this far. Can anyone help? Thanks.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question