Web Query using value in cell

[JBarta]

Not sure how to do this, and I am sure it is not too hard to do but I couldn't get it to work.

Trying to start up a sports spreadsheet and want to do a web query where a part of it is pulled from certain cells. For example this is the website I want the query to be pulled from, https://www.baseball-reference.com/players/s/stromma01.shtml but I want the "stromma01" to be pulled from cell B1. This way I can do it for each of the starting pitchers.

Sorry if its not completely clear, I can answer any questions if something isn't understood

Thanks,
JB

 

[JBarta]

It appears the URL didn't come across correctly. It should be that first part plus /players/s/stromma01.shtml