Sheet reference

Refer to cells in the other table using the following notation.

CODE

<Sheet number>!<R1><C1>:<R2><C2>

<Sheet number> ← sequential number from the top table which starts from 1

<Rx> ← row number which starts from 1

<Cx> ← column string which starts from A

Header is excluded from the cell position target.
1!a1 will have the value 1.