Using One sheet as a fill in table to populate data in Sheet 2 using A1 as Reference

Hi Everyone

I hope that someone can help me, I know there is Excel masters here and I know that Excel is capable of this.

I have two sheets that i work on, but both on one workbook. I Need to use my Sheet one as a input generator ( Not sure if I'm calling it the right thing ).

Basically I need to have on my sheet one A1 as a reference to where the data must be placed on Sheet 2. I thought of IFERROR and VLOOKUP, But cant seem to get the right things together.

I will attach two type of files, One being my template sheet for what I want to do and another One where i saw the idee, "Team Review Template" Is where i saw the generate review button that generates data of an entered employee name.

One " Template " I would like to use Sheet 1 A1 as a reference to add data to Sheet 2 in different cells. I Hope my explanation is well put together.
On " Template " Sheet1 The blue cells is the data i want to use for Lookup reference in Sheet2. Then when I insert data in sheet 1 it should populate it to sheet 2 as values so that it can be edited over and over.

Then when I " Submit Data " On sheet one it should paste the values over. But only when I use the " Button Control "
So if I add data in Sheet 1 A1 it should Lookup on Sheet 2 For the Line of data, Then if I enter data into Sheet 1 B1 it should be able to go D2 as value only. and Sheet1 C1 to Sheet 2 E1 and so on..

But I want to be able to over right the data every time.

Basically I run Maintenance on different sites and need to add the remarks to the list weekly, but want it to be a single input generator to prevent the list of getting messed up.

Hope That this is possible as i can not make my main list visible to my operators..