I have a workbook that is 106 sheets that consists of survey results.
Currently I puull all of the data off one sheet, then formulas drive the
remaining sheets. My thought is can I format a pivot table to look like a
table of contents to generate these reports?