On Sheet1, select C1 and do Insert > Name > Define Sheet1!relLeft refers to: Sheet1!B1 (no $ signs).

Enter =relLeft in in any cell on Sheet1 and it will return the value of the cell to the left.