Web query using URL parameter and dynamic range

Hi, I'm tasked with importing a pretty large data set into a single worksheet using many different URLs, each being identical but containing a different year (e.g. http://www.sports-reference.com/cbb/schools/air-force/[YEAR]-schedule.html#schedule::none , where [YEAR] goes from 2012 to, say, 1990). I understand the basics of setting up a web query and importing the tables one at a time using a .iqy file, but I need help automating it. What I'd like to do is concatenate these tables (each being 13 columns and around 32-35 rows) one after the other, so I end up with a table that's 13 columns wide and ~800 rows long. How do I tell Excel to start the next query in the row after where it left off?

If it helps, I have each URL individually listed in A1:A23, so I can reference those directly if needed.

Help is appreciated.

Hi

Welcome to the forum.

Some way down the line, I have been working on something similar on another forum and potentially have the solution to this problem.

Are you still seeking a solution?

Can I assume that the 13 columns of data is as represented on the web-page.