Please help!

I have a sheet which I have created and need to filter results. I was hoping that my option buttons would filter results for certain columns when typing required results in a search bar; I was unsure if it was possible... and if so, how?!

I haven't done any VBA for years and seem to have forgotten it all so I hoping someone could help in a foolproof step by step way.