Fetch values at the SAME INSTANCE

[hsandeep]

I am using DDE feeds in my Excel workbook in Sheet1 in cell addresses K1, M1 & S1 which are constantly being updated with the latest values.
In Sheet2, in column D (starting with cell address D1), I am constantly updating with the latest value of K1, whenever a change in value takes place in K1. Initially, D1=First value of K1. When K1 changes, D1= Second (latest) value of K1 & D2=First (previous) value of D1. Similarly, when K1 changes again, D1=Third (latest) value of K1, D2=Second value of D1 & D3=First value of D1. And so on the previous value moves down by 1 row & the current value replaces the previous value. I am using iteration method to do this.
At the SAME INSTANCE, when D1 gets the latest changed value of K1, I want F in column F & L, in Sheet2, (starting with F1 & L1) to get the PREVAILING value from M1 & S1 respectively (from Sheet1).
So, now when K1 is updated (second instance), F1=Second (latest) value of M1 & F2=First (previous) value of F1 AND L1= Second (latest) value of S1 & L2=First (previous) value of L1.
Similarly, when K1 changes again (third instance), F1=Third (latest) value of M1 & F2=Second value of F1 & F3=First value of F1 AND L1=Third (latest) value of S1 & L2=Second value of L1 & L3=First value of L1. And so on for the fourth, fifth ……………. instances should continue.
How to accomplish this? i.e. what formula should be punched in column F & L (starting with F1 & L1 & going down by 1 row). Please help.
hsandeep