Excel 2002

In Workbook 1 the value of cell A1 can be variable but always numeric. If,
for instance, A1's current value was ## how can I make cell B1 return the
value of cell Z## in Workbook 2? It would be helpful if the solution didn't
require Workbook 2 to be open.

Thanks for any help