List tabs

[Immatoity]

If you create a list like so

=MID(CELL("filename",'worksheet 1 name'!A1),FIND("]",CELL("filename",'worksheet 1 name'!A1))+1,255)

for each worksheet. You have to put the name in for the first time, but every time it gets updated, so does your formula.

xld..sorry but I need use of this ..however I create a sheet called summary and I want it to list all the tab names ( can be various) below each other in the one sheet called summary..will this work

[mdmackillop]

Something like
Sub Macro1()
Dim sh As Worksheet
Dim i As Long

i = 1
For Each sh In Sheets
If sh.Name <> "Summary" Then
i = i + 1
Cells(i, 1) = sh.Name
End If
Next

End Sub

[Immatoity]

excellent..works a treat thanks