Link cells to same location on multiple sheets

Headmelted  So I assume you are trying to do something like A10 = A9 + previousSheet!A10. But there is no way to reference something like thisSheet-1 in a formula.  Some options you have include VBA or lookup list for sheet names.  

Using VBA you could do a number of options but here is simple one [EDIT: changed this to be "Volatile" so it auto-calculates and doesn't require you to select the cell]:

Function pSheet()
On Error GoTo E
    Application.Volatile
    With Application.Caller.Parent
        pSheet = .Parent.Sheets(.Index - 1).Range(Application.Caller.Address)
    End With
Exit Function
E:
    pSheet = "N/A"
End Function

then you just use =A9 + pSheet()

But if you are not comfortable with VBA (I highly suggest you learn) or prefer to avoid macros to make the sheet more universal and not have issues with permissions you can also do this using a look up table.

So on another sheet let's call sheetNames you list off the names of all the sheets in column A

then use an indirect function like the following to in this case add A9 on this sheet to A10 on the previous sheet:

=A9 + INDIRECT("'"&INDEX(sheetNames!A:A,SHEET()-1)&"'!A10")