Get text from cell

Hello,

I want to get a text from a cell and use it as refference to another page.

Example:

In the attached excel i want to add in Calc Sheet in column B row 6 the value from Sheet1 A1 ; in Calc B7 value from Sheet2 A1; Calc B8 value from Sheet3 A2.
Instead of using in B6 Sheet1!A1 i want to get the text from Calc Sheet - A6 ( which is Sheet1) and then add A1.

I have no idea if it is even possible without macros, which i don't know.

Thanks.