Pulling Data From Websites - Data Extraction

[guitardude527]

Hello, I am looking to pull information from multiple pages on one website (data extract is the term I have been seeing mostly) and am looking for a simple solution. Long story short the info I am looking to grab must be selected after going through a couple clicks. Ie Base webpage -> select State -> select team -> pull data (team name, team color, etc) -> compile data in excel table. I need to do this for every state and every baseball team. I am very beginner to anything VBA or code, but looking for some help on a good way to do this! Please use layman's terms for any answers!! Thanks a ton to anyone who can help!
Starting webpage: States that have Baseball Teams - MaxPreps
Next Level Webpage: Alabama High School Baseball - MaxPreps (must go through all states)
Information webpage: Abbeville High School (AL) Baseball Home - MaxPreps.com (must go through all teams within the state)

 

[pbornemeier]

This post may help: http://www.mrexcel.com/forum/excel-questions/421935-scraping-data-web-page.html
More threads can be found by using google with this argument: screen scrape site:mrexcel.com