Duplicate Pivot Cache From SQL Connections

I'm using the same pivot cache for 6 pivot tables for 6 worksheets in a workbook. I'm wondering how I can use just one pivot cache. I'm trying to follow this post in contextures, but I don't think it uses SQL Connections and I am wondering what I am missing.

This is the code I get when I connect to make the pivot table from the SQL Server.

Please Login or Register  to view this content.

The question is, how do I write the source data above into the code below.

Please Login or Register  to view this content.

Thanks for the help. At minimum, writing this out will help clarify the problem for me.

This was solved by creating user buttons to pivot off the same data.