Control filter from somewhere else on the sheet

[tlacloche]

Hello,

Please see the attached workbook.

In Columns R:T i have a table with a filter in place.
There's a macro working which enables the filter to always be on in column R by hiding the N/A rows.

As you can see, I can choose to view what i wish with the filter. So under "Venue" I can select "Hall" and I'll be shown only the "Hall" rows...
Is it possible to be able to make these filter selections from C10:E10?

moving the original table is not an option im afraid

thank you

[tlacloche]

can someone please help