Calc Guide

identify where specific data may be found. A name such as Payroll or
Boise Sales is much more meaningful than Sheet1. The function named
SHEET() returns the sheet number in the collection of spreadsheets.
There are several worksheets in each book and they are numbered
from the left: Sheet1, Sheet2, and so forth. If you drag the worksheets
around to different locations among the tabs, the function returns the
number referring to the current position of this worksheet.
An example of calculations obtaining data from other work can be seen
in a business setting where a business combines revenues and costs of
each of its branch operations into a single combined worksheet.
Sheet containing data
for Branch 1.
Sheet containing data
for Branch 2.
Chapter 7 Using Formulas and Functions 193