data gathering from different sites and placing in Excel

I need a script that will go into the website [login to view URL] (password will be provided), and take a list of the symbols of certain stocks along with a little other information, go into the website [login to view URL] and go into the historical prices tab and provide me with the historical prices of that stock for a number of days. The final spreadsheet should be an excel spreadsheet which will be separated into various sheets. The various sheets will be based on the stock type of which I will explain how to determine the difference. The script would allow me to enter “from” and “to” dates for which the program would search for me what I was looking for.