Excel formula

[Rraducuu]

Hello! Please help me!
I have a list with products in column A (A1,A2,A3,A4,A5,A6) and in column B, C, D i have people who consume that products. I want to make a table, for each people, with his consumption.
For example, people from column B consum only productc from A1, A3 and A6. People from column C consum only products from A2, A5.

How can i make a table for eact person with his consumption?

Thx a lot !

[#2]

@Rraducuu 

Please attach a small sample workbook

[#3]

@Rraducuu 

Perhaps FILTER() will work.

[#4]

Please seee attached photos.
First photo is the main table with all products and all people. (Consumption worksheet)
Second photo is the individual table. (For ex. Charteres Consumption worksheet)
So, i need from main table to import only products which was consumed pe individuals, and not all.
For exemple "Charteres" consum only items from A6 & A15.
Be aware that i did not find =filter().
I am usint microsoft office 2013 (or 2016).

Thx a lot & in advance!

[#5]

@Rraducuu 

Please attach a sample workbook with some dummy data.