Copy a cell value each time a row is added without changing code

[KEMOwner]

I have multiple edited spreadsheets where one new row is manually added daily. Each row carries a value in A1 that needs to appear in Worksheet #2 - always updating cell H1. Example: Cell A1's value from Worksheet #1 shows in a cell in Worksheet #2 simply with the formula "=A1". When the next row is added I need the new value now in A2 to update cell H1 in Worksheet #2. I don't want to change coding each time a row is added. Will a macro do this for me without changing code?

[jindon]

Is it

Sheet2 H1
=INDEX(Sheet1!A:A,MAX(IF(Sheet1!A:A<>"",ROW(A:A))),1)
Confirm with Ctrl + Shift + Enter (Array formula entry)
?

[KEMOwner]

Yes that's correct - I will try that thank you