Recording value of a cell which changes daily

Hi

I have a worksheet which used various inputs to calculate a score value.
These inputs are updated daily meaning the output score value updates daily.

I have been looking for a formula that will allow me to automatically keep a record of these daily values to allow a trend graph to be produced over time.

I have been looking for a formulas that will automatically record this score value(cell D6) into another cell (D14). When the sheet is updated with the next days inputs cell D6 will automatically update. I would like for this new value to be recorded in to cell D15 whilst retaining the previous days result in cell D14 and continue in this manner, recoding the next days score value in the next cell below.

I have attached a sheet for reference.

Note: This whole example is a simplified version of what I am looking for as I hope to understand the process behind it. My actual sheet has multiple score values which I am looking to record and trend over time over the course of hundreds of days.



I have looked through various post on here and on the net and I am kind of getting the feeling I may have to use a macro or vba code. I am hoping to avoid this as I have literally no idea where to start on this and would have to spend a fair bit of time going over the basics of coding.

Any help would be much appreciated