Querytable and a list.

Hello everyone! I just started in the VBA world, but I get stuck with this problem. Hope anyone here got the solution at hand.
I have a book whit two sheets, one it's DATA, the other is GRAPHICS. In DATA I got a list of URL of which I have to import some tables in the sheet GRAPHICS, but the URL's change everyday (they are not fixed).
So I was wondering if there's a way to use the object Querytable to Copy&Paste the URL's one by one, to automate the process of import the tables; but I got the problem that in the object "Querytable" I need to put a fixed URL to make it work and the URL's change every day, my cuestion is if there's a way to make the "Querytable" select the list and look for the URL on that list alone?
Hope I have made me Understand and anyone's can help me.