Copy Multiple Columns of Data from Duplicates in 1st Column into Separate Sheets

Hello,

Perhaps I am asking for the moon here, but I am trying to get the data from column B and C into a separate sheets (tabs) for each 'brand' in column A ('A' is a brand, 'B' is a brand, etc.).

- Column A has duplicates and matches the name of the sheet i want it to go into
- Column B will not have duplicates within each 'childbrandabbreviation' but will have duplicates within the column
- Column C will have duplicates, it relates to both column B and column A.

Of course v-Lookup only pulls the first match, I need all of the matches. And this can certainly be copy/pasted manually but there are 100s of brands and over 60,000 part numbers.

An example is attached...


Any help is greatly appreciated.

Thank you,
Jason