you could use a user-defined function. insert a vba module in your workbook
and paste the following code:

Function SheetIndex() As Long
Application.Volatile True
SheetIndex = Application.Caller.Parent.Index
End Function

to use enter =sheetindex() into a cell.

"Sheets number position" wrote:

how do i return the sheet number position. something that would return the
value of 3 if it is the third sheet in a workbook of 5 sheets.