Converting multiple spread sheets in to 1 sheet

Hi,

I have been asked if we can convert our pick sheets into one sheet for upload into Sage. Attached is a sample of the master template for Sage...the actual has about 4500 lines of data. I have also attached a couple of sample pick sheets which are created for the customers. We may have 30 of these pick sheets at one time (usually containing much more data) that need to be converted into the Sage format. I currently have to open up a pick sheet, then search for the product in the master sheet and update the quantity for each style / colour / size, then do the same for the next pick sheet and so on... The only area on the master sheet that needs to be filled in is the quantity

Can anyone help me with a quicker solution...please let me know if you need any further info?

Thanks

Richard