Baseball player name excel data entry!!

This project is about data entry in excel and clicking back and forth a lot online. I'm a subscriber to a database of high school baseball players. They are separated by their home state. I need to create an excel file that has multiple sheets within it, with each sheet being a separate state. The particular sheet should have the players' name and contact info including the e-mail address. On the website, after you click on a particular state, it gives you the large list of players and their contact info EXCEPT for their e-mail addresses. You can copy and paste all the info directly into excel. But what you'd then have to do is click on each player's name individually to get to their e-mail address. After getting the e-mail address, you'd have to go back to excel and put it in the corresponding row of that player.