Vendor Price List Excel Macros

We have a series of vendors that provide us with their price sheet in their own format. Some are similar to each other, while others are completely unique. What we are looking for is a freelancer to build us a set of macros to format the price list we receive into our website inventory format with one click. I want the macro to be in the form of a VB file that I can import through the Developer tab in Excel and then just run on the vendor price sheet. If you don't understand or know how to do that, please do not post. I have attached one vendor, we use MAP pricing. The "format" sheet is the structure required by our website, the other sheet is what we receive from our vendor. There is also a sheet for available search sizes, your macro will have to approximate the exact "display" sizes to these "search" sizes. You must use only the search sizes listed. Please note that your macro must work even with additional collections added to/subtracted from the vendor sheet either in extra rows, or extra columns. So if the collection boxes in the vendor file are all organized into 1 column instead of two, or if they are separated into 4 columns it will still spit out the required data in the "format" sheet. You must obviously be skilled with excel and macro writing for this, messages without "vendor macros" in the subject will be disregarded. If you have questions about what to do, please don't post. This is straight-forward for somebody with the necessary skills. We have over 100 vendors. You would be payed for each vendor macro you complete. This project is for the macro needed for the attached files, we will workout payment for additional ones (probably with separate projects through GAF). Further clarification is available if needed.