[Nomad84]

='worksheetname'!E34 seems to do it. I just began entering a formula (typed an equals sign), clicked the appropriate worksheet tab, and clicked the needed cell. Excel then entered the correct syntax just as it would if I had clicked a cell in the same worksheet.

Hope this helps.