On your sheet "Current Hand Over" you use absolute references ( fi $D$8). When moved to another row, this ref will not change

To make sure, the ref changes when you change the row, use $D8 instead.


PS I hope the data you have published is a dummy....