Put the data in one workbook with all the pivot tables linked to that workbook. Then use..

ActiveWorkbook.RefreshAll