When your data is in sheet2 cell B4.
and you want this data in sheet1 you can make this link dynamic.

Sheet 1=
in cell A1 you type: sheet2
in cell A2 you type: =INDIRECT(A1&"!B4")

By changing cell A1 you can change the origin of the data.

regards,
Arie

--
Message posted from http://www.ExcelForum.com