Data retrieval (mining/scraping) from web to excel

I need an Excel workbook that automatically retrieves data from some specific websites for personal use. For example, I write a ticker symbol in a blank, click a button and it automatically shows me all the data that I want to see. This can be done through web query functions in excel. I will be using Excel 2016 and I need that all numbers retrieved are in a format that I can use for calculations. For example, if a number has letters or spaces, I need those characters to be removed so we only have numbers in the cell. I will provide all the specific web addresses that I need to retrieve data from, like Yahoo Finance and others.