Updating Pivot Table Referencing a Cell

[mnentertain]

I have multiple pivot tables on a worksheet and I want it to update the values based on a value in another cell. I am planning on creating over a 100 tabs so I would like a macro that would make the pivot table reference the cell in that specific worksheet it is located. Any help is appreciated.