I've finally gotten my storage capacity report doing what I want it to and have broken it into 3 sections in a scheduled report that sends an email with a link, a PDF and an Excel workbook.
The link and the PDF in the email both look and work great.
Unfortunately when I get the Excel workbook it has a tab for each section but I can't figure out how to generate the Excel with the tabs named anything other than Sheet1, Sheet2, Sheet3, etc.
Anyone ever created an Excel export with tabs named at creation time?
Here's my current version of the workbook...