This is from my notes. I have not personally checked recently. perhaps it will work.
In sheet1 (or any sheet) enter the sheet names. and NAME this range of cells as "Mysheets"
then use this formula
invoke this formula with CONTROL+SHIFT+ENTER