min max ordering

I am trying to create a stock table that will give me min max orders , this table needs to be updated by another spread sheet that is downloaded daily
I have created the table and inserted the formulas to calculate the order amounts as well as a pivot table to consolidate the information, however the issue I am having is that every time I copy the information from the new spread sheet it mucks up the alignment of the existing stock because new product may have been entered .
I have attached the two files to help explain where I am up to. any help would be appreciated.

Thankyou for the reply, however I don't think I was clear in what I need to do, as you can see from the files attached the test file is the destination that does what it needs to do , where I come unstuck is when I copy the data from the stock valuation report, it over writes all cells in the test file. I need it to update existing stock qty's and add in any new stock .

Yes, the second spread sheet is downloaded from the server every morning and I need to update the stock valuation table in the test file.
I need qtys updated and any new products inserted., hope this helps