Hi

You can use an UDF. The one below returns tab name from tab's index (order
number)

---------
Public Function TabByIndex(TabIndex As Integer) As String
Application.Volatile
TabByIndex = Sheets(TabIndex).Name
End Function
---------

P.e.
=TABBYINDEX(3) returns the name of 3th sheet in your workbook


Arvi Laanemets

"Sundus" wrote in message
...
Dear Sirs,
I work daily on excel and lately I needed to view my sheet tabs all at
once
so I wamted to print them out and I did not know how?