Calc 2.0 In Pictures

Employ absolute references
  1. On the Revenue sheet, click cell B4.

    Notice the formula in the Formula Bar:

    ='Numbers Per Costume'.E8*Sales.A4

  2. Place the cursor on the Fill Handle, then drag it to cell C4.