Transfer row entries onto another spreadsheet/form

Hi

Can anyone help...

I am trying to link information from one spreadsheet onto a form my office are using. At present they make an entry into a spreadsheet one row at a time and the information they input into the row (4 columns) they then re-input into a second spreadsheet, an internal form. I have put the spreadsheet and form onto one file (sheet1 and sheet2). Is there any way this can be done automatically, seems mad to repeat this process. The desination cells to the internal form would be different from the original spreadsheet:

By this I mean
Sheet1 Column A goes into Sheet2 Column G Row8
Sheet1 Column C goes into Sheet2 Column F Row14
Sheet1 Column F goes into Sheet2 Column B Row20
Sheet1 Column H goes into Sheet2 Column F Row16

Any clever ideas?