Problem to reference a cell or range of cells in another worksheet in the same workbook

Hi,

I've got a problem to reference a cell or range of cells in another worksheet in the same workbook.




In Sheet1 I've got text (A1:A7 and A9:A15) as well as cell A8 for which one I look in Sheet2 for a value which is in B1.

Now if I copy down I want to have:

Sheet1 A23 to return value from Sheet2 B2
Sheet1 A38 to return value from Sheet2 B3
Sheet1 A53 to return value from Sheet2 B4

Any idea on this?
Many thanks in advance