xml and webcraping data to master spreadsheet set 3 and 4

We are a small business that uses drop shipment from our suppliers to our customers. We have selected the inventory from our suppliers to include into our catalogue which will be available to our customers (master spreadsheet), therefore, not all the inventory will be used from our suppliers hence our master spreadsheet. Some of our suppliers will provide us with a live feed (XML) of their stock including the pricing and the stock level and some we will require data to be pulled from their website for our desired products. This will need to be done on a daily basis, our master spreadsheet needs to be updated with stock and pricing level everyday automatically using macros or VBA macros which will ultimately be uploaded to our opencart store. To recap our requirements: Master spreadsheet of the chosen products from all our suppliers need to be updated (stock level and price). Roughly 600-700 products. 4 or 5 Suppliers. Note, the distributor websites require a log in and password and we are currently working with 4 distributors.