automatically move rows based on data

i have a workbook with multiple sheets that, I am trying to get excel to automatically cut and move a row of data from one sheet to another when data is contained in a cell within that row.Let me break down what i am trying to do. On the first sheet labeled stock locations contains layout of products placed in a warehouse, the second sheet labeled new items is where i will place info of new items that does not have a place in the warehouse yet, and then we have the third sheet labeled product list where it has the entire list of products with all their data. I want to move the row of data for new items to the complete list of products automatically when i find a location for the item, so once there is data in the row under the column new stock location it should be moved. in that cell i have a formula that searches the first sheet for the item and if it finds it it displays the location of the item where i placed it and it shows as blank when i have not placed the item yet.

i uploaded the workbook to have a better idea of what i am trying to do. if anyone can help or point me in the direction of how i can get help with this it would be great thanks a lot.

yea after it relies that it has a location and moves it to the other sheet it should erase the row off the new item list

that be awesome thanks

I'm trying to get this to run but doesn't seem to be working

i had it entered the way you have it but nothing seems to change at anytime. what do you have triggering the event