Excel MACROS expert needed - API knowledge

I am looking to drop ship from a European company Pixmania Pro - [login to view URL] I have a domain with Godaddy [login to view URL] Pixmania supply the following CSV file link [login to view URL] ….which is updated every day – and I need to update my Ecommerce platform website every day. This lists approx 12,000 products and I want to show approx 1,400 products from the total to specialise in printers and ink etc Bottom line I need what is called I believe a ‘push and pull’ API solution i.e. I need to use this Pixmania link CSV file so that every day AUTOMATICALLY my website will just show the 1400 products and as a drop shipper I need some of the prices on the CSV file to have an additional 25% on certain price and 30% on ether prices… updated AUTOMATICALLY EVERY DAY This then uploads to my Ecommerce platform daily automatically - all created from the one Pixmania feed as shown above