I am no Excel-whiz, so any help is MUCH appreciated...

I created a workbook with worksheets for each position, etc and one sheet containing variables to be used in my projection equations. For example:

Sheet 1 (point values)

Stat 1 = 1 point (in cell B3)

Stat 2 = 2 point (in cell B4)

Stat 3 = 3 points (in cell B5)

Sheet 2 (projections)

PLAYER A

Stat 1 = 25 (in cell B3)

Stat 2 = 50 (in cell C3)

Stat 3 = 75 (in cell D3)

Here is the formula I have to calculate the projected total points for PLAYER A using Sheet 1's point values:

=(Sheet2!B3*Sheet1!B3)+(Sheet2!C3*Sheet1!B4)+(Sheet2!D3*Sheet1!B5)

How do I copy this formula for 100 other rows of players and keep the Sheet 1 cell references constant? How do I copy it across to other worksheets and keep the Sheet 1 cell references constant?

Here is the formula I get when I copy the cell to the next row:

=(Sheet2!B4*Sheet1!B4)+(Sheet2!C4*Sheet1!B5)+(Sheet2!D4*Sheet1!B6)

When the formula I want is:

=(Sheet2!B4*Sheet1!B3)+(Sheet2!C4*Sheet1!B4)+(Sheet2!D4*Sheet1!B4)

Or is there a more efficient way of calculating the values?

Thanks in advance.