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...
I don't know a way to do this via the UI, but if it was a critical need for some reason you could probably create your own method and reporting through API and your language of choice to do it.