Sorting Data based on a report my software spits out

Hi,
I am in the final stages of touching up my upselling spreadsheet for a smoothie bar.

My software prints an aggregrate sales report ( total sales for each staff member) this is cut and pasted into the aggregate tab

It also prints a Report on what each staff member has sold in each category.

I collate this information on the staff kpi table

It has worked fine but now I need the staff kpi table to break it down more

In the category tab there are 5 categories ( Boost drinks, Boost Snacks, Boosters, With, Promotions)

Can I break the staff kpi report down so you can easily see which amount of each category each staff member sold?

MANY THANKS IN ADVANCE FOR YOUR HELP, IT IS VERY MUCH APPRECIATED.