Preset filter combination based on client

Hello there,

I know my way around excel more or less.
I have made a table of all parts we sell in the company. It uses many items and has many columns and rows (price size etc...).
I used filters in the table so as to remove the parts we dont need and leave the parts we need according to the client.
I have made another table with all the clients we have. I made a drop down list that points to each client.

let's say client 1 buys items 3 5 and 6.
client 2 buys items 37 43 and 67.
client 3 buys items 7 55 and 91.

How do i make the drop down list point to the list of items of the client?
For example when i choose client 1 in drop down list, i want items 3 5 and 6 to be ticked in the filter only. (I want it saved as template to re-use for all clients).
I thought about using =nameofclientindropdownlist in the last column of the filtered table, but the value only shows 0. Apparently formulas dont work on filtered cells. If the formula had worked, then it would only tick the client in the formula (thats what i was trying to do)

Thanks!

nbnb.JPG
njj.JPG

The orange table is just a list of customer and the drop down beneath it contains the name of the customers linked by using Vlookup
I want the parts of the black table to be filtered according to the client in dropdown. Keep in mind that an item can be bought by many clients so i cant use filtering in clients and add it as a last column.