I have played around with trying to export information to multiple
worksheets within the same Excel Workbook. Can this be done? If I
set my script variable ($ExportPath) and use it for multiple Exports
or Save As Excel, it creates the file, but no worksheets.

I am reporting on 14 territory based sales regions across the US. The
script:

Finds the correct info for Territory 1
Sorts based on summary fields
Goes to layout with sub-summary parts
Exports

Finds the correct info for Territory 2
Sorts based on summary fields
Goes to layout with sub-summary parts
Exports
etc... through all 14 territories

After my script creates the multiple Excel files (14), I drag the
worksheets from all workbooks into the first workbook. It only takes
a few seconds, as I have the script naming the worksheets, but it
would be great to generate only 1 file with the worksheets already in
there. Can I Export or Save As Excel all territories into the same
workbook?

Or, maybe it's me needing to create a more complex sub-summary
layout....... bleh.