Update Multiple Pivot Table Filters Based on Value of a specific Cell

[ensmith]

Hello All,

I am trying to update multiple pivot tables filters based on a specific Cell F5 (Worksheet 1) . Need to update pivot table filters (Op Unit) in Worksheet 2 and (Op Unit) in Worksheet 3: (OT). Thanks

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>

Worksheet 3: (OT)

Op Unit	(All)
Values
8-19-17	25867		PivotTable Name: PivotTable7
9-2-17	24862
9-16-17	18361
9-30-17	25351
10-14-17	24267
10-28-17	25230
11-11-17	24499
11-25-17	17155
12-9-17	23054

<tbody>
</tbody>

<colgroup><col><col><col span="2"></colgroup><tbody></tbody>