I hope this makes sense, it's my first post.

I have an employee timesheet with 26 worksheets. In each worksheet I have some columns where I need the formula to refer to a cell in the previous worksheet to add previously accumulated hours to this pay's accumulated hours. so my formula looks like this s9 being that employee's current hours plus the previous payroll's hours ('PR1"!v9):

=S9+'PR 1'!V9

My problem is, when I try to paste the formula on all worksheets, instead of referring to the previous worksheet, it is always referring to PR1. (On PR 8 it should refer to PR 7 so the formula should be S9+"PR1"!V9 and so on). How do I select all sheets and put in the formula so it refers only to the previous worksheet? Or do I have to do it one worksheet at a time? Can anyone help?