Hi, please help me to solve this problem.

I just need a code that will do something like this:

ActiveCell.FormulaR1C1 = "='SheetName'!R4C"
were actual SheetName depends on the value entered in inputbox.

All help will be highly appreciated. Thank you so much!
hydz1213