ZSS should support creating reference between two sheets.
1. In sheet1 range A1 type "="
2. Click sheet2 and change view to sheet2.
3. Click sheet2 range B1, then press "enter"
4. Switch view back to sheet1 automatically and range A1 value is a formula "=Sheet2!B1"