Take a look he

http://www.mcgimpsey.com/excel/formu..._function.html

In article ,
ash wrote:

I know in order the insert a value from another cell we type =(the cell
number).

What if I want the value from the tab (by default, they is sheet 1, sheet
2,....).

for example, If i rename the tab as 123, and i want my sheet 1 cell A1 to
have the tab value (hence 123), what should i do?