Updating a pivot filter with another pivot updated by a Slicer

Hi

I have this problem which I have simplified below:

Sheet 2 contains a Pivot table. One of the report filters is "Month-Year" (Eg, May-14 - in date format 'mmm-yy') which is selected by a Slicer on sheet 1.

Cell D1 on Sheet 2 contains a formula which calculated/displays the mmm-yy of the same period last year (eg May-13).


I want a code so that when I select the 'Month-Year' Slicer to filter the pivot table on Sheet 1 (eg to May-14), another Pivot on Sheet 3 is filtered with the previous year mmm-yy (May-13).


Any help is most appreciated.

Cheers

Any ideas?

Thanks stephenloky.
Do you mean use the same pivot? The example I've given is simplified, but i need to filter on the second formula derived date in a separate pivot table.

I think so.
The problem I have is I need the macro to run when the slicer updates the 1st pivot, to update the 2nd. And not sure how to do that.