Update cell based on another sheet

Hello.

Simple question I think. I need to update cell D:19 on sheet 1 with the value in cell H:7 from sheet 2. But I'd like to update D:19 later on from sheet 2 but this time from the value in H:8 and so on.

So D:19 is static and needs to be populated with H:7, H:8, H:9, H:10 .......

Thanks in advance.

my code so far:

Please Login or Register  to view this content.

Cell D:20 on sheets("DaveCheck") for example is calculated with an idex match function in that cell. Im having trouble getting the value in that cell placed from thrr value from sheets("DaveM") coulmn I. The index function looks up a value based on the value next to column I in column H ie I2 refers to H2, I3 refers to H3 and so on as the rows increment downwards. I need cell ("DaveCheck")D:20 to get its value from sheets("DaveM")range I:2 after the first user input. After the second user input I need cell D:20 to get its value from I:3. After the 3rd user input D:20 gets its value from I:4 and so on.

I have no problem transfering any of the other values. But since Im trying to get a value from a cell that has an index function within it Im getting tripped up.