Help with reporting - filtering makes report messy

[targus92]

I have a sheet that has alot of data. I am trying to create a report page or a summary page that makes it a little easier to read the data and be able to present the data. I have formulas using a Match and an Index formula to retrieve data for certain columns (sales, GM, Exp, Bop) for each month depending on the metric i select (highlighted in light blue)

The issue I'm having is if I use a filter for example to selection only K and only UT's then I have blank rows that happen inbetween and it doesn't look good. I don't know if I should use look ups on a speerate worksheet but ideally what I would like to have is if I select S and Sales and IT then thats what will come up but it will be clean and no multiple blank rows between each section.

Can someone help me with this please?

[targus92]

.bump.....

[targus92]

help please.