I am trying to import this page into an excel sheet in my workbook. I currently have it set up as a power query, which kind of works. I then have another sheet to organize the raw data. The problem I am having is every time BaseballMonster updates, the location of the information changes on the raw data sheet. When this happens I have to change the formula on the "Lineups" worksheet (where I organize everything) to point to the new cell location. It is extremely frustrating and time consuming. I am posting here in hopes of a more efficient and accurate way to pull the data. I am thinking that a VB script may be the way to go but not really sure where to start with that. If someone could direct me to a tutorial on how to tackle this or at least where to start, that would be much appreciated. Here is an example of what I would like to accomplish. Thanks!
