Copy value cells between sheets to update

Ok. So reference would be fixed and new data will keep on appending on the other sheet.

Yes only solution would be vba.

Reards,
DILIPandey

<click on below star if this helps>