When you build the range string you can use A1 or R1C1 references.
Variable Row y A1 Style
wSheetstr = "='" & wSheet.Name & "'!"
Worksheets("Scorecard").Cells(ScorecardRow, 1).Formula = _
wSheetstr & "A" & y
Variable Row y and Column x A1 Style
wSheetstr = "='" & wSheet.Name & "'!"
Worksheets("Scorecard").Cells(ScorecardRow, 1).Formula = _
wSheetstr & Cells(y,x).Address
Variable Row y and Column x R1C1 Style
wSheetstr = "='" & wSheet.Name & "'!"
Worksheets("Scorecard").Cells(ScorecardRow, 1).Formula = _
wSheetstr & "R" & y & "C" & x