How to get a value of data from the last rows of a table. sheet1 content a
data table. Data rows is increasing daily. Sheet2!A1 is showing the last data
entered in sheet1.

All this while i am using =sheet1!$D100 to get the data, but I need to
update the formula daily. Is there any formula for this situation?