Excel Macro or Add-in to pull info from Amazon API

General information for the business: we sell items on Amazon
Description of requirements/functionality: 1) Progress bar in excel when pulling info from amazon when lookup request is intiated
2) Ability to switch between Amazon API credentials to process API lookup
Specific technologies required: excel, amazon api
OS requirements: Windows, Mac OS
Extra notes: Please create an Excel macro or add-in that uses Amazon's API to pull the following information into the Excel spreadsheet:

1. Title,
2. Manufacturer,
3. MPAA Rating (Movie rating)
4. Sales Rank,
5. ASIN,
6. Weight,
7. Dimensions
8. UPC,
9. Manufacturer Part Number,
10. Amazon’s Price (return 0 if they are not on listing),
11. Buy Box Price
12. Number of AFN Sellers in New Condition,
13. Number of MFN Sellers in New Condition,
14. Lowest AFN Price,
15. Lowest MFN Price,
16. Sellerprep required? (polybag, merchant label)

Let me know if you need any further clarification.

Thank you.