如何在插入新数据时停止excel更新单元格引用

I have a spreadsheet which takes in certain parameters that I update every day. This is then inserted into a separate worksheet which holds all inserted data. I then use this data to take an average of the latest 5 entries to smooth out day to day variation: e.g.I have a spreadsheet which takes in certain par