Reference another sheet

Select the cell where you want to create the reference.

Type = (equal sign).

Select the tab of the sheet to reference

Choose the cell or range of cells to reference and press Enter.

Select the cell where you want to create the reference.

Type = (equal sign).

Select the tab of the sheet to reference

Choose the cell or range of cells to reference and press Enter.