Adding/Deleting rows, columns, and more automatically.

I have an Excel (I use 2003, 2007) issue that's driving me nuts. After I run a report from a program I am using, it will generate ugly, raw, data. I want to clean up the data so it looks more presentable and visually digestible.

The data changes daily, however, some parts will be static like the row groupings (the number of rows per cluster will change), placement of the "totals" and some columns.

When I make this report/sheet, I want to delete the highlighted headings (they are unneeded), space out the row clusters, and add a total for each cluster of rows, and finally a total of all the "Row Totals" all automatically or with as little manual intervention as possible.

Attached is a bare-bones example of what I want as my final product as a visual. I hope I was clear in what I am looking to do. Any questions, ideas, suggestions, criticisms, etc are much appreciated.