Pivot Table - Combo Box Selection

[bsnapool]

Hi,

Apologies if This thread has already been posted but struggling to find anything which has helped me.

I am looking to Have a combo box which dives the weeks selection in my privots on my master sheet.

I.e. If I select 8, I would like all the pivot tables in that sheet (three of them) to change to the same week as in the combo box?

Any ideas?

Any help appreciated...

 

[bsnapool]

Anyone with any ideas?