Sorting blocks of multiple rows is very hard work. There are better solutions. Chiefly, it involves separating your raw data from the data you want to see (your various 'reports'). The raw data remains the same (except when you want to change it) but you present it elsewhere in the ways you want to see.

You managed to respond without answering either of my questions! However, I have some more:
What data does each column (20 of them) contain?
What version of Excel are you using?
Strongly suggest you attach a workbook (adjusted to disguise sensitive data without losing realism).
Are macros allowed?