This is either very easy or just can't be done.
I want the first worksheet in a workbook to display a list of the other
worksheet's name.

Within Sheet1
cell A5 should return the name of Sheet2 (as renamed on the tab)
cell A6 should return the name of Sheet3
and so forth

Any ideas would be very much appreciated.

Thanks, Rick