VBA To create Text based Pivot Table

[genichigo]

Hey guys, I've been working on this one for a while, can't figure it out since my knowledge of VBA is limited but from my research VBA only comes to be the solution

I've included the sample of the table.

Essentially i wanted to create a Pivot table system to be able to filter through the data on this sheet. I wanted ideally the "Verticle" to be a drop down menu which will have a range options to filter the pivot table down

The table would then show the company, business manager and account manager and all of the data after it, so we can quickly looking through it to see if people have attended events ect.

Any idea's on best way to approach this?