Urgent Help Please - Macros not working on Mac only

Hi, 

I am having some trouble with the attached spreadsheet.  I think I need a replacement for MSXML2.ServerXMLHTTP.  I have seen that I may be able to do this with Query tables or something here: https://stackoverflow.com/questions/15981960/how-do-i-issue-an-http-get-from-excel-vba-for-mac  However I am not sure how I might do this.

Any advice would be really great!

Thanks in advance