Pull data using drop-down list (URGENT - ATTACHED)

sample.xlsx

See attached.

I have completed the drop-down list. I need the option selected to pull all the jobs that have that parish from the Works Record tab.

Thought this would be easy but my vlookups aren't making unique, neat lists. Just lots of gaps and N/As.

Needs to be a unique list without duplicates.

Any help would be a god send. In a massive hurry!

Thanks