Lets simplify my question by saying that I have a workbook "Calculate", and two others called "2018" and "2019".

In Calculate I have a pivot-table "Pivot1" which has data from workbook 2018, sheet1 A:C.

Is there an easy way of updating Pivot1 so it changes source from workbook 2018 to 2019 but still fetches from A:C?

Thanks for all help!