Tie cells in multiple SpreadSheets together with VBA?

[logius]

Is it possible to tie cells across multiple spread sheets together so that VBA can reference them? In other words have Worksheets("Sheet1").Cells("A1") refer to Worksheets("Sheet2").Cells("E4") so that the two data values in the cells can be tied together later on using only VBA?

----------------------------------------
If you are reading this, then you have read too far...

 

[Zathras]

I don't know what you mean by "tie together", but if you use the macro recorder while building a formula with "point and click" with the mouse, you will be able to see the syntax that can reference outside worksheets (and even outside workbooks).