[reg45]

=Sheet2!B9

[reg45]

Another cool thing is that if you rename a sheet, the new name will propagate through all the links.

for example:

If you have =Sheet2!B9 and then you rename Sheet2 to MySheet, the link will automatically change to =MySheet!B9.