Filtering Columns of Data (Named Ranges) based on Brand Names

Hi Everyone, I am trying to filter columns of data (named ranges) that are on same Excel spreadsheet based on brand names... I want the results of what have been filtered on a different spreadsheet....