Looking for a Macro or other tool to create a Workbook Content Sheet

[Victor]

i am looking for a possibility to create a sheet with the contents of al the
worksheets that are in the file you are working in.
Input for the sheet with contents would be a specific defined cell (let's
say the content is in Cell A1 of each worksheet) + the name of the tab of
the worksheet.

 

[Pete_UK]

David McRitchie has code and explanations here:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

(Second time today !!)

Hope this helps.

Pete