Couldyou put this code into the cells you need the data?
=[sheetname]![cell where the original is]
so if you has a sheet called MyData and you wanted to copy the data in cell A5 it would be ...
If your sheet was called My Data (with a space in it) the code would be ...
I really appreciate thank you messages as a payment for solving issues :o)