Hello,
I've a spreadsheet with multiple sheets called "Obsevations (1)", "Observations (2)" ... "Observations (20)".
I need a summary page, and want to copy cell E16 from each of the Observation sheets.
I have tried by going: =Observations (1)!$E$16 and dragging, but the reference to the...