Duplicate Report Filter and Row Labels Filter Across Multiple Pivot Tables

Hi - Looking for some help on the following:
I have 3 pivot tables on one sheet sourcing from the same data set. I have the same Report Filter (Month/YR) on each Pivot table and the same Row Labels item as well (Material Numbers). I would like to select single values on Report Filter and multiple values on the Row Labels on the first Pivot table, and would like the same selections shown on the other two pivot tables. I have read a few posts and tried some of the code but when i applied a filter on the first pivot table, the filters did not change on the second and third pivot tables.

Sample of sheet for easier reference Sample Tables - Updated 02 15 13.xlsx


http://www.excelforum.com/excel-gene...-criteria.html

http://www.excelforum.com/excel-gene...ot-tables.html

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Target.Address = Range("B2").Address Then Exit Sub
    Dim PT As PivotTable
    Dim ptItem As PivotItem
    On Error Resume Next
    For Each PT In Worksheets("Sheet1").PivotTables
        With PT.PivotFields("MyReportField")
            If .EnableMultiplePageItems = True Then
                .ClearAllFilters
            End If
            Set ptItem = .PivotItems(Target.Value)
            If Not ptItem Is Nothing Then
                .CurrentPage = Target.Value
            End If
        End With
    Next
End Sub