Sort by Sheet Summary fields in Row Report
I am curious whether there is a means by which I can use a Sheet Summary field to group and/or sort rows in a Row Report. For example, I want to give a group of sheets a "Priority" field (1, 2, 3, etc.) and then in a Row Report, be able to sort rows by the priority number associated with the sheet where the rows are contained.
Is there a means by which I could accomplish this or, if not, some other simple workaround to achieve this? I wanted to avoid having a priority number in each row so that if I want to re-prioritize my sheets, I could do so quickly without having to change each row.