Inventory management system in excel

I have a very specific need and have created most of the software myself, I will have to explain the business to you on call for clear understanding of what is expected out of the entire project. The sheet is macro enabled, there are no malicious files in the attachment.