How to automatically generate multiple sheet tabs in your Excel workbook based on an existing list of values. Create sheet tabs from your list then make a table of contents tab with hyperlinks to all the other tabs. Generate your tabs automatically without having to manually type them out and without VBA. Use this Pivot Table trick to save time and auto create multiple sheet tabs from your list of values. Then create a master sheet table of contents in Excel that has hyperlinks to all the sheet tabs in your workbook.