Autofilter with multiple criteria listed in a range

Hi All,

Is it possible to create an autofilter based on criteria listed in a range?

I'm hoping to save myself time by creating multiple automated reports from the same data using a few different criteria ideally stored in a hidden sheet.

e.g. the below structure is broadly what I had in mind.
- Column B being the source data and Column D representing Column B after autofilter criteria in Column F is applied.

Screenshot 2024-05-13 144846.png

Thanks Romperstomper, didn't actually think of this and it's exactly the solution i need