I have an array in 'Workbook B'

'Workbook A' contains a cell, say A1, in which I've Calculated a variable
cell reference

How can I obtain the value held in the un-open 'Workbook B' from the cell
defined in 'Workbook A' A1?

Thank you