Select the destination range (a range equal in dimensions to the input
range).
Enter =Sheet2!B2 and press Ctrl+Enter. The formula will be copied
throughout and the cell references will change accordingly.

Does this help?
Kostis Vezerides