I have a calc file with 201 sheets, the 201st is called Totals. I would like to display the contents of a cell from the Totals sheet … for example, in Sheet 1, I want the contents of cell G1 of the Totals sheet. In Sheet 2, I want the contents of cell G2 in the Totals sheet. The closest I can come up with is >
=Totals.G&“Sheet()”
Haven’t been able to figure it out. Thanks!