software

When trying to do a copy/paste of the first three line I get what is
showned; but I would like to the progression to go on with: 31, 37, 43
and so on for the next 30 lines or more.

=Sheet1!$E13*DAY($A13) Sheet1!$E14*Sheet2!$D$5-DAY($A13) original
=Sheet1!$E19*DAY($A19) Sheet1!$E20*Sheet2!$D$5-DAY($A19) ..
=Sheet1!$E25*DAY($A25) Sheet1!$E26*Sheet2!$D$5-DAY($A25) ..
*no blank line here*
=Sheet1!$E16*DAY($A16) Sheet1!$E17*Sheet2!$D$5-DAY($A16) copy
=Sheet1!$E22*DAY($A22) Sheet1!$E23*Sheet2!$D$5-DAY($A22) ..
=Sheet1!$E28*DAY($A28) Sheet1!$E29*Sheet2!$D$5-DAY($A28) ..
=Sheet1!$E19*DAY($A19) Sheet1!$E20*Sheet2!$D$5-DAY($A19) ..
=Sheet1!$E25*DAY($A25) Sheet1!$E26*Sheet2!$D$5-DAY($A25) ..
=Sheet1!$E31*DAY($A31) Sheet1!$E32*Sheet2!$D$5-DAY($A31) ..
=Sheet1!$E22*DAY($A22) Sheet1!$E23*Sheet2!$D$5-DAY($A22) ..What I am doing wrong or what chapter of excel should I look for?

Den