Excel export named sheets

When exporting to an excel workbook, i.e. with multiple sheets allow the user to name the sheetts

It either takes the truncated name of the query or the excel default name i.e. sheet1 etc...

I have several exports running that get sent by email to third party clients and I need to name the sheets manually or create views with the names I want the sheets to be, however this approach doesn't follow are DBAs naming conventions.