Another way to manually add a table of contents in Excel is by using the Hyperlink Function. In this method, you need to type all the names of your sheets and add hyperlink formulas to each one ...

This article explains how to create a report in Microsoft Excel using ... sheet into your pivot table. The pivot table collates all of the data for multiple items by adding them (by default).