thanks DanWall I think there is better way like this 
ws.range("a1").currentregion.clear
but I no know where I put this line, it gives me error
for more explanation
in sheet123 it brings data from sheet "data"
1 asd123 EXPIRED 20/11/2020 08/12/2020 18days
when I copy again should not happened every thing stay as is it , but when change data like last column change days 12 days instead of 18 days should overwrite old data not copy to a new row to the bottom
I hope this help