Change a pivot table based on a selected cell

[ensmith]

Trying to link Cell F5 (Worksheet 1) to the pivot table filter (Op Unit) in Worksheet 2 to change the pivot table when a new value is entered in Cell F5. Thanks for your help

Worksheet 1: (Summary)			Worksheet 2: (Pivot PSC Vol)
OP Unit:	189		Op Unit	(All)
	Cell: F5
					Values			PivotTable Name: PivotTable1
					Wk 28	976284
					Wk 29	1014784
					Wk 30	1002135
					Wk 31	1003555
					Wk 32	1016709
					Wk 33	1024173
					Wk 34	1021025
					Wk 35	1018841
					Wk 36	945889
					Wk 37	951032
					Wk 38	1014143
					Wk 39	1015068
					Wk 40	1005054

<tbody>
</tbody>