Auto Copy/Paste row by row between sheets.

[blastronaut]

I'm sorry if the thread title isn't perfect. I'm having a hard time putting it into words. Here is my problem:

On Sheet3, I have a list of data, 3 columns across and 1300 rows long. It is a list of variables.

I need to find a way to copy the first set of variables, Sheet3(A2:C2) into Sheet2(A2:C2). This will trigger a ton of calculations on Sheet1 that will return a result to Sheet2(D2). I need to then copy Sheet2(D2) to Sheet3(D2) and repeat the process.

The data from Sheet3 will always be copied into the same 3 cells on Sheet2. For example:

Sheet3(A2:C2) is copied into Sheet2(A2:C2). Then, Sheet2(D2) is copied into Sheet3(D2). Next it would be, Sheet3(A3:C3) are copied into Sheet2(A2:C2). Then Sheet2(D2) is copied into Sheet3(D3) and so on.

Is there a way to do this automatically so that I am not copying and pasting for 2 weeks?