The basic theory is everytime when I change the datecell under current, it
will automatic copy(link) to the next row instead override the same row
Does anyone know if excel has this ability to function this?

Your reply is highly appreciated~!

Current 100 40 200 150
Summary
1-Jan 100 40 200 150