Excel 2007 : Problem in a simple Inventory Sheet

Hi,
I shall be very thankful if someone helps me to manage my inventory sheet.
Attached is the inventory sheet.

Is it possible that when I sell a product and changes its status in column A to "Sold" this record automatically moves to sheet 2 (Sold items) and when the item is again in stock and I remove it's status "Sold" it automatically comes back to the main sheet.

and 2ndly how can I link the records in column B to the other sheets on this file. Like there are 3 type of parts in Column B (new,old and copy parts) and I need their copies on their relevant sheets as well (See the file)
if In future when I add 3 items 1 new , 1 old and 1 copy part to the full inventory sheet. they automatically copies to their relevant sheets on my excel work book.


Thanks a lot for reading.