Web Scraper - ESPN

A web scraping application (please respond with the ability to write the application only), with preference given to VBA/Excel, that pulls the information contained for each shot in a link such as this: [login to view URL] The individual shots are described thusly in the HTML code as seen on chrome's 'inspect element': <a href="#" abbr="x: 2, y: 27" id="shot-400818870102964900" class="shot player-66136 period-2 away shot-made" data-teamid="2127" data-playerid="66136" data-firstname="Patrick" data-lastname="Wallace" data-details="#4 G" data-status="3:50 - 2nd Half" data-playtext="Patrick Wallace made Layup." data-color="#2e3192" style="left: 24px; top: 134px;"><span class="team-color" style="background-color: #2e3192; border: 1px solid #2e3192;"></span><span class="shot-mask"></span></a> This information may only show up in 'Inspect Element' after clicking on the 'shots' tab, near the top of the page, between Recap and Game Flow. It should be noted that not every link will contain this 'shots' tab; the routine should exit/terminate if this button does not exist. Would like the output to be a .csv, .txt, or on the excel sheet with each of the pieces of data - including but not limited to - abbr, id, class, data-playerid, data-firstname, etc., laid out in the same row for each individual shot log. Please only respond with a full understanding of the project. Would prefer not to award, and then explain what I'm looking for - why I went to the trouble of looking into what I wanted as much as I have the ability to.