Hi all, I have a series of pivot tables (18) that I use weekly.

I am constantly updating the Data Source on all 18 pivot tables every week.

Is it possible to link the data source of the pivot table to the CONTENTS of a cell, so this way I can adjust 1 cell, and then all the pivot tables will then have their data source updated?

Thanks