Help re how tho reference the 'next filled in row below'...

Hi

I am hoping for some help to find a way to reference the last filled in row in one column of figures in a single static cell elsewhere (another tab / table), but to have that update when ever a new row is completed with a new value.

So, I will have a column that once a day I add (fill in) a new row below with an updated figure and I want that column to have the full history of updates each day. In the other table I just want to show in a static cell the 'most recent / updated figure' from the column with the history when a new value is added in the next row down as and when it is filled in. In cease it makes a difference the data I will be dealing with is a 'percentage'.

Eg.

TABLE 1:

COLUMN HEADINGS: 'DATE' 'VALUE' 'VALUE CHANGE' 'PERCENTAGE CHANGE'

ROW 1 06/04/21 1000 0 0%

ROW 2 07/04/21 2000 1000 100%

ROW 3 08/04/21 2500 500 25%

TABLE 2:

CELL A1: [always the last value from the 'PERCENTAGE CHANGE column in Table 1 - updating when ever a new row is competed in that column].

Many thanks for any help offered in advance...