Question

Eg of reference of another worksheet: ​

Answer 1

Explanation:

As you know, the usual way to reference another sheet in Excel is writing the sheet's name followed by the exclamation mark and a cell / range reference, like SheetName! Range.