I have six tables that have identical columns.

The columns are:

Product code, Sales, Counctry, Currency and so on...

I know how I can create a pivot table for each individual table. But is it possible to create a pivot table with rows from all the tables?