If all the data is on one sheet, you may be able to create the reports
from a single pivot table. If you provide details on what you want in
the report, someone may be able to offer specific advice.

Scott@CW wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html