I'm not sure if the subject question is clear so I will try to explain...

I am creating a spreadsheet which fetches the price of commodities via web api along with max/min/median sells etc. from various locations.  Each commodity has its own item ID, there are 35k+ commodities.

My choice is to create individual columns for each location of which there are 40+ or create a drop down list at the top of the column to select the location.  The issue with the latter brings me to my question...

Is it possible to automate the change in the function calling the data from the web api in the cells below when a user changes the location in the drop down list?

This is the web call I use at the moment >>> =FILTERXML(WEBSERVICE(locationID3&itemid),"<webapiurl>/type/sell/min")