Move a row but only some columns

Hello I am trying to to split a row from a form entry and send 3 columns of that row to another sheet but not the rest of the row. Is there any way to do this without any add-ons? I cant have any vlookup or Index/match on the destination sheet so I have been trying to use a helper sheet but as soon as the first row is moved the helper sheet is blank and wont fill with the next row unless i manually enter data in a cell.

Thanks Ross