Save / record dynamically changing values of a cell in a column with date time stamp

Hi experts,

Sheet 1: Pulls data from web say every 15 minutes.

Sheet 3: Calculates values using a formula.

Sheet 2: Cell D2 pulls values from Sheet 3 using Vlookup function. The values in D2 keep on changing dynamically.

Requirement:

Sheet 2 , Column E should record the value of D2 every time it changes.

Sheet 2 , Column F should record the date and time stamp everytime a cell in Column E is populated.

Sheet 2 , Column E and F will keep on growing with every update in Cell D2.

Eg:
D2= 25891 , E2= 25891 F2 = 20/02/2019 10:00
D2= 25900 , E3= 25900 F3 = 20/02/2019 10:15
D2= 25800 , E4= 25800 F4 = 20/02/2019 10:30


Tried to use a code from https://www.extendoffice.com/documen...ng-values.html Sample file attached.

But it works only if the values in Sheet 2 Cell D2 are changed directly and not by using a formula as in my case.

Kindly help.

Thanks,