Refer a cell to another's sheet Data, where the sheet's name is written in a cell

Ill try to explain what i need to do:

I have a name written on a cell, for example name "sheet1" writen on A1. That name is variable.
So, for cell B1 for example, i need it to be equal to cell C1 from "sheet1". That would be like:

B1='sheet1'!C1

No problem there. But now, i need to let the sheet to be a variable, so i can write on A1: "sheet2", and the formula changes to:

B1='sheet2'!C1

Hope i did make myself understand, ill appreciate any help! Thanks! Greetings!

Formula:

Please Login or Register  to view this content.