Assume that Sheet2 is your master sheet in which the data will get added continuously...
In A1 Cell of Sheet 1
=LOOKUP(2,1/(Sheet2!A:A<>""),ROW(Sheet2!A:A))
In A2 Cell
=INDEX(Sheet2!A:A,$A$1)
Drag it to right...
So now whenever the data gets added in Sheet2 then the Last entry will reflect in Sheet1 Row 2![]()
Bookmarks