Looker Studio Filter

I have 3 google sheet data sources, the first two have data for individual departments and the third lists those departments with rollup categories like "Division"

I want to build a blended data sources which will allow me to filter all of the data by "Division"

Essentially I want Looker Studio to lookup which departments belong to that division and filter the report to those department

0 1 92