Cell content in URL
 

I would REALLY like to put a cell's value into a URL in a web query to
retrieve a certain page. In my case, a product number in a different
worksheet that when added to a URL will give the desired product page. The
product page does not have labeled tables, forcing me to import the entire
table and take C15 every time. If it was possible to simply perform this
action without another worksheet/table, please let me know.