VBA script to extract data from server

hi,

Is there a way to write code in VBA to extract data from server ?
Is it possible to do it in Excel(VBA) ?
I have attached sample how to extract the data from server ?
Currently been doing it manually and its time consuming. please help if can as need it urgently.
Any help much appreciated. thanks in advance.

any experts on this ?