have problems doing excel forumlas that are page linked - any help please?

Answer 1

On Sheet1 cell A1 type a value, say "Hello World"
On Sheet2 cell A1 type =Sheet1!A1 and hit the enter/Carriage return key.

Is that what you want?

This can also be achieved by going to cell A1 on sheet2 and typing =
Then go to Sheet1 and clicking on cell A1 Now press enter/Carriage return key.