I have two seperate workbooks and each contains I pivot

I would like to use the Pivot from the second workbook on the first workbook


I have copied and pasted this. I would like to create a relationship between the two pivot tables or if there is another way so that when the Pivot on the first workbook is updated/refreshed, this pivot data on the second workbook is updated as well


It would be appreciated if someone can advise me on how to do this