Very nice-- works fine and is very helpful...
How about a list of only VISIBLE worksheets?

-KIM W

"T. Valko" wrote:

Try this...

Create this named formula
Goto the menu InsertNameDefine
Name: SheetNames
Refers to:

=GET.WORKBOOK(1)&T(NOW())

OK

Assume you want the names listed on your Summary sheet starting in cell A1.

Enter this formula in Summary A1:

=INDEX(MID(SheetNames,FIND("]",SheetNames)+1,255),ROWS(A$1:A1))

Copy down until you get a #REF! error. Delete all the cells that return the
#REF! error.

--
Biff
Microsoft Excel MVP


"treen" wrote in message
...
Is there any way to display a worksheet name in the cell of another
worksheet. Example: Worksheet names 1, 2, 3, Summary. I want the Names 1,2
and 3 to display in cells on the Summary worksheet. These sheets are all
in
the same workbook.

I have seen answer for getting the worksheet name to display in a cell on
the same worksheet but not different worksheet names.