I don't have much experience with web queries or macros but was wondering what the best strategy was for importing box scores from a website like NFL.com. The URL changes on a weekly basis as new box scores become available. There are also a large number of games each week, all of which have slightly different URL's. How can i create a spreadsheet that will import all of the current weeks box scores that I can refresh for each week of the season? I'm trying to create a worksheet that will score my league's fantasy football games based on the players stats from these box scores. In the past I've manually copied all of this info into the worksheet because I wasn't sure how to have the information imported automatically. Any help would be much appreciated! Thanks