Analyze some Data from Excel using Amazon

Hi there, I'm in the Media business and most of my job requires me to do buying and selling. My suppliers usually send me excel lists of their inventory and as a price and popularity reference, I usually use [login to view URL] to check the price and rank of these titles. The lists that I usually receive from my suppliers usually have the UPC codes, the title, the quantity and my cost. What I usually do is, go on [login to view URL], copy a UPC code from the excel list, then paste it to the search field on amazon, and then the product information comes up. I usually like to gather: - the Amazon Ranking of that title - the [login to view URL] retail Price - the LOWEST 3rd party seller NEW price - the Average 3rd party seller NEW price - the LOWEST 3rd party seller USED price - the Average 3rd party seller USED price - Which Amazon site the UPC data was pulled from (Please pull data from [login to view URL] first, if it doesn't find then try [login to view URL]) and specify in this column if it's from the .com (US) or .ca site (CAN) By doing this, this allows me to determine what titles to focus on when doing my buying. If a supplier sends me a list of a few titles, I can do this manually, however, if the list has a few hundred items, the process can take a long time. I would like a custom software that will allow me to input an excel or csv file, and for the program to analyze each UPC code and output another excel sheet with the added 6 columns mentioned above. Please note, sometimes suppliers send me product UPC codes with UPC codes that begin with the number 0, but excel tends to automatically remove the number 0 and therefore when copying and pasting nothing comes up, however, if adding the 0 first, then the product will come up. So you may want to write a line in the code stating that if amazon can't find the listing in the original format then try adding a 0 in the beginning of the UPC code. Also, sometimes, my supplier will add a " ' " (an apostrophe) before the number so that the " 0 " will show up as the first number, if you have trouble pulling up listings, then have the software remove the apostrophe. Last please take into consideration that the UPC column isn't always column A, it variest between suppliers. I've included a file as an example of how I sometimes receive these lists from suppliers. Need this program as soon as possible.