How to run a multiple queries and build one table

wildcat829

New Member
Joined
Sep 21, 2014
Messages
1
Hi All,

I have very limited knowledge on using VBA and macros so I was wondering if someone could help me with the following problem.

I wanted to build one table that contains all of the data from this URL and all of the pages listed at the bottom:

LaxPower Recruits Databases

The very last digit of the URL refers to the page number and the number of pages generally goes up to 50.

Is there any way in which all of the data from these 50 or so sheets could be combined into one table within excel? Any help would be greatly appreciated.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,108,999
Messages
5,526,167
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top