CMS sorting based on secondary CMS collection

Hey all,
On my page /shop/all … For each card within my CMS collection ‘Products’ , I’m trying to display the brand and brand’s location based on the information provided in the separate CMS collection: ‘Brands’ (which itself has a State/Province reference field coming from a third CMS collection)

I’m also trying to figure out how I might be able to pre-filter the products displaying on a given page to be limited to ONLY display brands from a given state / province. My intention is to create separate pages for each state/province so people can discover local brands.

Thanks so much for any help you can offer!
TJ

Here is my public share link: LINK
(how to access public share link)