Sorting while maintaining subtotals

I have a spreadsheet with nested subtotals. i need to sort it based on one of the nested subtotals, but maintain the rows that comprise the subtotals, together with the subtotal.

is there a way to do this? I don't want a macro because then the whole project will be done as a macro. this is just a small part of what i am doing.

any help would be appreciated.

sample included. my goal is to sort by column F (ABS value) high to low so that rows 8-13 are together and maintain the subtotal and on top, then rows 34-36 are together and maintain the subtotal and are next, etc.
I am in Excel 2007.
is this even possible? or would it have to be all manual? i hope not!