If it’s related to VBA code, you can view code by Visual Basic Editor:
(By View -> Toolbars -> Visual Basic to show Visual Basic Toolbar)
If it’s about cell reference, same sheet reference is little bit different from other sheet reference.
Referring to same sheet: =ColumnRow. e.g. =B22
Referring to other sheet: =SheetName!$Column$Row, e.g. =Sheet1!$A$6
Functions can be used in reference, e.g.
=SUM(A2:A10)
= SUM(Sheet1!$A$2:$F$2)
HTH
If it’s about cell reference, same sheet reference is little bit different from other sheet reference.
Referring to same sheet: =ColumnRow. e.g. =B22
Referring to other sheet: =SheetName!$Column$Row, e.g. =Sheet1!$A$6
Functions can be used in reference, e.g.
=SUM(A2:A10)
= SUM(Sheet1!$A$2:$F$2)
HTH