How do you reference another worksheet without using its name

[dallen917 via OfficeKB.com]

The standard way to reference a cell on another worksheet within the same
file is Sheet2!A1. How can I create a reference that basically says A1 in
the next worksheet irregardless of its name (i.e., current worksheet + 1).

 

[Jacob Skaria]

Use =INDIRECT(A1&"!A2") where A1 = "<sheetname>"