Excel Sheet Customization for coordinating Shipments.

I need a freelancer to build out an excel sheet that allows me to upload 10 or more different shipping plans into the document. Those shipment plans each have a number of products going to different warehouses. The products in my inventory are mixed and going to different warehouses. Each product has a custom barcode that is listed in each of the different shipping plans. I need the ability to pick up a random product, scan it, and then be told via excel which warehouse/shipping plan that it belongs too. I have a version of this excel sheet that used to work, but somewhere along the way it got broken and stopped functioning properly. This particular excel sheet allowed me to color each warehouse/shipping plan and give it a custom nickname. When the product was scanned it would display the color and name of the warehouse. I need to be able to continually scan 500+ products. So the excel sheet needs to be able to scan the product, show me the color, and then prompt for the next scan. After scanning a barcode the scanner gives the value of the barcode and a "return" or enter. One initial challenge is that some shipments might have two of the same item, and those two items might be going to different warehouses. In this case I need the document to recognize that and give a quantity number per shipment. I've attached the old excel sheet and 3 examples shipments. If you can please review these excel sheets and let me know the total cost to make it all functional and working again that would be great. When bidding please mention "coffee" in the beginning of your bid so that I know you understand and read through my text wall. I'm looking to have this ready within the next 4-6 hours max. The barcode when scanned returns the value that starts with X########.