Hey there, im trying to figure out the formula to automatically copy a full row on sheet1 to sheet2

i found some formulas but they aren't working for me...

for example:

excelexample1.png

Input formula (or macro) and it will get put into the following highlighted area.

excelexample2.png


OR

Does anyone know of a way to create a form on Word or adobe, that can be filled via .csv or any other type from excel?