How to filter multiple columns in excel using the same auto filter?

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)

Thank you very much!

In which case is there any way of setting up a series of simple dropdowns or similar so that people who haveno idea how to use advanced filters can simply select 'Oranges' or 'Mangoes' and it applies that already-created advance filter? To save other people using the file hassle...

It's basically a cheap way of getting around buying a database system, and teaching the end user is out of the question sadly.

Attached is a sample from the data (editors in publishing houses, and the genres they buy) - data is over 800 entries long, really need a way to filter by genre (spread over 6 columns)

I got an error trying to upload to the forum, so I have uploaded to Megaupload: https://mega.co.nz/#!nYFllBJB!0rX0lX...mHH5tGwB5Ix_UQ

Just bumping this to see if I can get an answer.

Elsewhere, someone suggested using MATCH, but that throws up an error message...