Thank you very much for this information. I will explore the addin.

Dave


"Ashish Mathur" wrote in message
...
Hi,

You cannot specify a 3D reference in the Name box. I suggest you use the
morefunc Excel addin and then use the sheetname formula.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dave P" wrote in message
...
Greetings,

My goal is to return a list of worksheet names on a sheet called
"Summary".
I have 30+ sheets. The first is Named "First" and the last is Named
"Last".
In A1 of each sheet