Using Excel and VBA to get API/Web Data with Multiple Queries

Hello all,

This is my first post and I would be grateful if you could help me . I have spreadsheets with a large amount of data for querying. I am looking for each cell of data to be searched through API/Web Query and then resultant from that specific data to be extracted to Excel. What is the best way to go about searching multiple queries so to speak? Would it have to be combined with a macro which searches one cell after another?

I appreciate your help.

I have attached a sample file along with the URL which needs to be queried.

Thank you!