Auto transfer of row/ update

[alanled]

Hi Im trying to setup a system for our 'goods in' the attached sheet would be on a pc at the 'goods in ' area hooked up to our network. In the office we have a individual parts list for each job. I want to be able to input a component on the parts list and when I enter a order number in the cell at that row it will copy the row to a row on the attached sheet (goods in). When the tick box is ticked i.e the component is 'in' I want a cell on the parts list (in the office)to say 'goods in' or some kind of alert. Any help would be great someone has suggested using a VLOOKUP but I havent got a clue how to start. Many thanks.

[alanled]

Sorry will add attachment!