Type `=` in the cell where you want the reference
Click the sheet tab you want to reference
Click the cell you want to link
Press `Enter`
Use the format `=SheetName!A1`
For sheet names with spaces, use single quotes: `=’Sheet Name’!A1`
To reference a range, use `=SheetName!A1:B10`
To reference another workbook, use `=[WorkbookName.xlsx]SheetName!A1`
To create a fixed reference, add `$` signs: `=SheetName!$A$1`
To copy the reference across cells, use relative references like `=SheetName!A1`