Fix my data scraping spreadsheet

This excel file (is attached to this project) gets financial data from several websites. The way it works is very simple: you input a ticker symbol next to the "enter ticker" cell (XOM or AAPL for example) in the first tab (HomePage tab) of the file and click "get data". After 1 or 2 minutes, the data retrieving is done and all tabs are filled with the correct data from the internet. The problem is that the tabs that scrape from Yahoo Finance are not working now. Those tabs are: [login to view URL] Statistics [login to view URL] Estimates [login to view URL] Statements [login to view URL] Sheet [login to view URL] Flow [login to view URL] Prices I will gladly give $100.00 to anyone that completely fixes the problem (that means every cell pulling the right data). However, some people have told me that the problem can not be solved after I have set a milestone, so I will not fund the project or set a milestone until someone provides evidence that they can fix it. Using AAPL as an example, Key Statistics tab gets info from here: [login to view URL] Analysts Estimates tab gets info from here: [login to view URL] Income Statement, Balance Sheet and Cash Flow tabs get info from here: [login to view URL] Historical Prices tab gets info from here: [login to view URL] You can ask me any question, thanks