Hi,

This requires VBA.
A simple macro can be created which will copy data from CONTRACT and paste in INVOICE #1 every time you do something on CONTRACT sheet. This can also be triggered via a custom button. If you are fine with this, would request you to upload the sample workbook containing above mentioned worksheets. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>