[SOLVED]Reference cells and pivots in other tabs

I know this is easy stuff but I am rusty on my VBA and just need some help with this code:

Please Login or Register  to view this content.

I want to modify this code to change the pivot field "IP1" in PivotTable3 in a sheet called "ARAP" to match the value of cell B8 in a sheet called "REF"
I am no longer using the active sheet. Both the pviot table that needs to change and the value I need to change it to are in different sheets from the button that executes the macro.

Thank you so much for all your help around here!

Thank you so much!! I know this is simple stuff, I just haven't done programming in a while!