I am trying to get data from multiple pages to their own sheets via VBA but I am having an issue with the web address changing and my vba using the previous days input. Even though using the macro recorder was used to copy the web address that was updated the query uses the old info it saved from the previous day. The sheets are named Game1, Game2, ...etc, and all have the correct web address listed in cell Y1 which is also named Game1Web, Game2Web ...etc. 

Please Login or Register  to view this content.
The section that is giving me the trouble that I would like to pull in the data in Cell Y1 is:
Please Login or Register  to view this content.
I have already built the formula to get my web address correct but need to get that data into the query and not save the old data.....

Thanks