To reference cells from another sheet in the same workbook, you can use the sheet name followed by an exclamation mark (!) and then the cell address. Here's how:

1. Click the cell where you want the referenced value to appear.
2. Start typing the formula with an equal sign (=).
3. Click the tab of the worksheet containing the cell you want to reference.
4. Click the cell you want to reference.

Example:

- If cell A1 on Sheet2 contains the value you want to reference, in your formula, you would type: `=Sheet2!A1`

Additional Notes:

* You can reference a range of cells from another sheet the same way. For example, `=Sheet2!A1:B5` would reference cells A1 to B5 on Sheet2.
* If your worksheet name contains spaces or special characters, enclose it in single quotes. For instance: `='Sales Data'!A1`
* By default, Excel uses relative references, which means the formula adjusts based on where it's copied. Absolute references can be created using F4 to lock onto specific cell locations (e.g., `$Sheet2!$A$1`).