Adjoining Cells

[Carla]

I have two worksheets in one spreadsheet. I want to be able to change 1
number and have the next cell down display the cell adjacent to the cell I
input. For instance, if I specify Worksheet1 A1, I want the next cell down
to display, Worksheet1 B1. Is this possible? If so, what is the formula or
function?

 

[Max]

Use 2 cells, one to house the sheetname, another to house the cell ref

Input the sheetname in A1, eg: Sheet1
Input the cell ref in A2, eg: A1

Then place in say, A3:
=OFFSET(INDIRECT("'"&A1&"'!"&A2),,1)
A3 will return the required contents of Sheet1's B1