I need the data to link over to Sheet2. If A1, A2, and A3 in Sheet1 are the result of a calculation then to simply use this doesn't work:

'Sheet1'A1
'Sheet1'A2
'Sheet1'A3


Naturally, an error message is going to pop up instead of the actual value. I am not interested in supressing this message but in getting the actual value to appear.

I could do a paste special an select 'value' but this is a problem as well. My data won't change with a change on Sheet1.

Any advice?