Excel Data Roll-up with Fixed Headers

I have a mixed-data Excel spreadsheet that needs some alterations. The data needs to roll up multiple times on one tab, specifically 8 times from 0 to 8 degree headings. The project requires the following:

- The spreadsheet has various types of data (text and numbers), so a keen eye for detail is crucial to ensure all data is correctly accounted for during the roll-up process. Dont change any of the data that has already been entered
- I need the data to roll up from 0 degree heading to 8 degree heading, which means understanding the structure of the spreadsheet and navigating it with precision.
- All 8 headings need to stay fixed if I roll up each section below that heading, so experience with Excel's 'freeze panes' or similar features will be necessary.
- I want all 8 headings to stay visible and not hidden when rolling up each section below that heading. I don't want any of the headings to be able to roll up past the other headings

This needs to happen on all tabs in the excel file. I have managed to get the top one to roll up in each tab and that is it

Ideal candidates for this project should have extensive experience with Excel, particularly with data manipulation and roll-up functions. Attention to detail and the ability to follow instructions precisely are key to ensuring the project is completed successfully.

If there is anything that you need to clarify contact me