Another Pivot Table Macro post...but possibly unique?

[brainiack18]

Another Pivot Table Macro post...but possibly unique?
Hi all,
Thank you in advance for taking the time to read this. Here is my saga:
*Please read whole before you judge that I am a dimwit :D
My boss asked me to make a macro that would create a pivot table. I am aware that there are a lot of posts in and out of this forum that have advice on this matter. I have read through a good number of them and there are two reasons why I have resorted to asking for help in a post.
1. I am a noob when it comes to macros and have difficulty when I have to do tweaking to the VBA code after C/P it into my excel sheet.
2. The excel sheet has ever changing columns and rows. While this is not a unique problem, the information that my boss wants on the pivot table will not always be in, for example, column B. It might very well change to column CCC. The information he wants will always have the same column title though. Also, he wants two pivot tables on the same page.
Some notes:
-The info my boss wants are in the columns named "Salesperson, Contacted, and Feedback Received" They may not always be in the same columns though.

I realize that these are simple pivot tables that I can create manually in a minute or two. However, I have to have a macro. Is this even possible to do? I thank all of you Excel/Macro/VBA gods.
*I have an example file if that would help

 

[brainiack18]

I can email the file to someone willing to take a look