Excel queries from the web

What you are asking is possible using VBA. There is a code in this link that shows how you can use VBA to add queries. If you have some basic knowledge of VBA then you can set up your links into a Table and then the VBA to be modified by adding for each loop to run on each of the links that are placed in the cells. So, again there are lots of unanswered questions here, how links data looks like, what part of the data to be fetched and included and what data from web to be excluded.

so, I am not sure how badly you want this automation. I am not sure if someone here will do the whole project for you, you probably need to hire a professional VBA developer to do this for you and I guess adding 120 links manually will probably outweigh the hustle of creating automation for this.