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

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.

Looking for a Macro or other tool to create a Workbook ContentSheet
 

David McRitchie has code and explanations he

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

(Second time today !!)

Hope this helps.

Pete

On Feb 7, 3:18*pm, "Victor" wrote:
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.