Hi There. I have a pivot table that gives me the total spend per month by the number of product codes. This shows me the spend to date and the amount still to be invoiced.

I have linked the data from the amount spent per month, and amount still to be invoiced to another spreadsheet. However, when I go into the other spreadsheet., the links aren't showing
the correct information. I'm guessing this is because the pivot table has expanded perhaps with new product codes and the link is still linking to the specific cell which now isn't holding the correct data.

Is there a way that as the pivot table expands, the correct data remains with the link?

This is driving me mad and id be really grateful for some support x