There is the obvious of typing = then selectign the cell from the prior
worksheet, but I assume you want the process automated. Since the sheet names
can vary, I don't know if there is any code that will cover that. May want to
check within the Programming section of this group...

"Jeff Korn" wrote:

I want to refer in let say the current cell B74 of the current worksheet the value of
the cell E53 in the previous (=next left) worksheet.

In other words if I enter the value 4567.89 in cell E53 of a worksheet that exact this value should
appear in cell B74 of the next right worksheet (regardsless if the labels/names of the worksheets).

How can I setup such a reference?

Jeff