Linked label updates

[chef]

This is a strange one and not sure how happening or what I am doing wrong.

I have automated 16 separate worksheets for separate departments and included is around 12 labels on each pointing to cell references with a value in each and fed from a source that is updated each month end.
The issue I have is that they dont update automatically for some reason and the only way around is to double click on each and every label which then updates then I have to re format each label.

I am looking for an easier way as the whole point in first place was to automate as much as poss and negate manual intervention

Any help or ideas would be greatly appreciated
regards

 

[Skybluekid]

How do the sheets update?

 

[chef]

Sheets are updated with a mixture of sumproduct from separate source update but the labels are a mixture of just pointing to cells from source sheets sheet and other labels are just a percentage calculation between result of pointed cells value
It's a strange one?