With the 26R1 release, users can configure a specific worksheet order for Workbench Report Sets exported as an Excel Workbook.
After you have configured this feature, see Generate & Run Report Sets for more information.
Configure the Workbench Report Set Layout
To update the Workbench Report Set object layout, in the applicable sections, edit the default columns to include Report Set Worksheet Index.
Configure the Download All as Excel Workbook Action on Workbench Report Set
To configure the Download All as Excel Workbook action, assign the action to the Workbench Report Set object and add the action as a user action to the applicable states of the Workbench Report Set LC object lifecycle.