I have an excel spreadsheet with multiple word-values over 6 columns.

These values are not necessarily the same per column, but the same value could be in A1 and B3 and C6, but I want a filter to include all instances.

For example, 4 people's fruit preference:

Arnold: Apples; Bananas; Oranges
Berty: Apples; Oranges; Pineapple; Cherries; Mango
Charlie: Oranges; Mango; Papaya
Drew: Pineapple; Bananas; Cherries; Oranges

Now if I want to filter by Oranges, consider they are in A4, B2, C1 and D4, how do I create a filter that will do that for me (and all the other fruits to boot)