Extracting specific rows from master XLS extract by business area

Summary

Extracting specific rows from master XLS extract by business area

Content

I have a source that produces a master extract with Actuals by category and half year, with a section total

The end report is broken up by business area and each business area just needs a subset of these categories with an appropriate change in the section totals

How can this be achieved without creating a separate custom extract sheet for each business unit

Almost needs a Business Unit - Category lookup and match on all categories that match the Business Unit lookup