Can I copy the names of the tabs to cells in a worksheet?

[cheesysocks]

With the help of many people here I have almost finished my graffiti reporting system. Many thanks.

I have used the 'bookends' system as reccomended in here to store sheets from other workbooks. It works well, and as I can move the start and end sheets around I can create summaries that encapsulate any range of other sheets. Cool or what?

I want the title in my Total Summary sheet to reflect which sheets are currently being enclosed by the 'bookends', so I want defined cells to reflect the names of these tabs. How, please? Google has shown VBA for using data in named tabs and other stuff I know nothing about. Is there a function rather than VBA?

Thank you.