Response to "Can I get a list of names of all the tabs..."
 

Couldn't reply, so posting as new!

Write a Function, in VBA like:
Function tabName(idx As Integer) As String
tabName = Sheets(idx).Name
End Function
(Alt/F11; then Insert/Module. then put in the above).
In the worksheet, enter
=TABNAME(ROW(A1))
and fill down for as many sheets as there are.