I have a list of URLs in a workbook:

A1: www.site.com/table1
A2: www.site.com/table2
A3: www.site.com/table3
(and so on)

Given an entry in another cell, say B1, the appropriate URL from
column A appears in C1.

I am trying to figure out how to create a dynamic data import that
will pull the selected data from the web given the URL in cell C1.
The site I am pulling from contains very consistent data, so the table
selections all of the imports are the same, but the URLs will change.

I have hunted around for awhile in this group, but I can't find
exactly what I am looking for. Please help!