Pivot Table and Cell Reference

[cmrluvitlevit]

I have a pivot table that has all of my project numbers and current costs associated with cost codes. I want to create a code that will take the project number in cell F1 and this will go to the 'Project_ID' in the Pivot Table, then filter the pivot table on the Project_ID.

It must also refresh the pivot table to external data through the refresh button.

I have been struggling with this for a day now and could use some help.