Switching Between Two Unit Sets, Power Pivot (ADVANCED)

I would, but I know this will cause problems for me down the road.. It already has (a minor one), as when I create a pivot table, it won't let me take the "sum of" certain columns. Says there's a error calculating. I didn't bother trying to figure it out, because I know this method is not stable. I'm thinking about creating two separate tables and creating a dropdown macros with the code:

  Private Sub Worksheet_Change(ByVal Target As Range)

     If Not Application.Intersect(Target, Sheets("Pivot Table").Range("B2")) Is Nothing Then
        Application.EnableEvents = False
        If StrComp(Target, "PivotGOP", vbTextCompare) = 0 Then
            Sheets("PivotGOP").PivotTables("PivotTable8").TableRange1.Copy
        Else
            Sheets("PivotRev").PivotTables("PivotTable9").TableRange1.Copy
        End If
        With Range("A15")
            .PasteSpecial Paste:=xlPasteValuesAndNumberFormats, _
                          Operation:=xlNone, SkipBlanks:=False, Transpose:=False
            .PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
                          SkipBlanks:=False, Transpose:=False
        End With
        Target.Select
        Application.EnableEvents = True
     End If

End Sub

This will allow me to toggle between two separate tables/charts, but the problem with doing it this way, is that I plan on having 16 charts and tables in total. So I'm afraid this will cause a strain on excel... I just know there has to be a better way of doing this... Why is it so difficult to group column sets?