Run Macro to filter data based on Data Validation

Hope someone can help.

Is there a way to automatically filter a list of data based on data validation, much the same way as would automatically happen if my data was a pivot table?

I can't use a pivot table because I the report I am generating is interactive (i.e. requires input from the field). Additionally, other variables not in the list depend on the data validation (which I currently have working on VLOOKUPs from a table).

So, I'd like the user to choose their division from the data validation cell and I'd like that to automatically filter the list below to their division's data.

Any ideas anyone? Thanks!