I have to keep a shift summary report which is divided into different daily functions which include things like lunch and breaks.
now on sheet1 I have a template which is 27 rows long, I copy and paste this template down for each employee and they fill it out accordingly.

the totals are displayed and then summed up with eachother on Sheet2.
this is the formula I use on sheet2 to reference sheet1:
=SUM(IF('Sheet1!F29:F48=('Sheet1'!$A$42),('Sheet1' !E29:E48)))
now when I copy and paste this formula it comes out as:
=SUM(IF('Sheet1!F39:F49=('Sheet1'!$A$42),('Sheet1' !E30:E49)))

but I want it to go down 27 rows to catch the same category on the template for the next employee and come out as:
=SUM(IF('Sheet1!F56:F75=('Sheet1'!$A$42),('Sheet1' !E56:E48)))

and so on and so forth..
=SUM(IF('Sheet1!F83:F102=('Sheet1'!$A$42),('Sheet1 '!E83:E102)))
=SUM(IF('Sheet1!F110:F129=('Sheet1'!$A$42),('Sheet 1'!E110:E129)))
=SUM(IF('Sheet1!F137:F156=('Sheet1'!$A$42),('Sheet 1'!E137:E156)))

is this possible? Or do I have to keep inputting this stuff manually?
thanks in advance.