Filtering pivot table based on cell value

I have a WB and I have tried several methods/codes to have my pivot table filter according to the numeric value in another sheet but no success.

The cell that contains the value is on sheet "Demographics Summary" and is E5
The pivot table is named PivotTable1 and is on "pivot" sheet, the filter field is named "Location"

I tried the below code in the "Demographics Summary" sheet module:

Please Login or Register  to view this content.

And to the right of my pivot table entered:
='Demographics Summary'!E5

This was one of many codes but looked like it was simple and would work but it's not. Any ideas?