How can I get data to automatically update using a master sheet?
 

I have an Excel 2003 workbook for an inventory project with 1 tab showing all
the movement of various products over the last year. There is a column for
the amount of said product being originally put in, a sum column which shows
the amount still left in this location, and a sold column where I put
negative numbers for the amount of that product sold out of said location. I
would like to set up a "Dead" tab where data is transferred to when a
negative number is put in this sold column. Is this possible, and how can it
be done?