Can't link Shapes to Variable cell references

New data is added each week to the next free row in Cols J - N of the Production worksheet.
Need Macro to "copy and paste" the latest date and four values to the five Shapes in the Summary worksheet.

At the moment it generates an "Error Code 91":

Please Login or Register  to view this content.

All solutions, suggestions and alternatives welcome as ever.

Ochimus

Try this:

Please Login or Register  to view this content.

Artik

Artik,

Many thanks for prompt response and solution.

Irritating that I spend HOURS yesterday hunting for this on here and other sites, none of which threw up the "TextFrame" requirement you spotted!

At this rate I will be blackmailing the grandchildren to master ChatGPT so they can write Codes for me from scratch - they're the only ones that can handle the Home entertainment system as it is!

Ochimus