Record an ever changing cells value from Sheet 1 every 30 seconds into Sheet 2

Hi

I have little knowledge of vba and I wonder if someone could help me with my problem please.

I need to take a record of an ever changing cells value in Sheet 1 every 30 seconds and place it in cell A1 of Sheet 2. Then 30 seconds later record that cells value from Sheet 1 again and this time place it in cell A2 of Sheet 2. Then cell A3 and so on, continuously into a separate cell each time in column A.

Or another option would be to record the information into cell A1 every time and then push the cells down so that the new record always goes into A1, but this seems harder I think.

I hope you can understand what I mean and many thanks to anyone who can help.

Thanks for your help Pierre. As I said, my knowledge of vba is very limited.

Do I just copy & paste this into vba?

And how do I link column A in Sheet 2 to the cell (say cell C2) in Sheet 1? I have tried a formula to point to the cell but I can't get it to work.

Thanks again.

That's great Pierre. It's just what I wanted. Thank you so much for your help.