VBA coding; control cell that controls pivot table filter

Hey guys,

I know there have been several threads on this topic. I've visited them but haven't been able to get the VBA to work for my spreadsheet. Basically what I am trying to do is use a range of cells in another worksheet Called Eexcutive summary to change my pivot table called detail by package to change my pivottable (pivottable2) filter (Ins Pkg id). Is there anyone who can help me?

also i forgot to say that this is an extremely large spreadsheet, the pivot table itself is around 70,000 plus rows

anyone?????