Help needed (creating VBA macro to retrieve stock info)

Hey,
I am fairly new to excel programming and just looking for some help on a personal project. (Please view file first to get and overview of what I'm looking to do)
I would like to create a VBA macro that would be able to retrieve stock info based on my worksheet. Moreover I would like to like the the vba macro to allow for database expansion (i.e. allow user to input new data on a daily basis (get alert info)

Any help is appreciated
Btw, would it be a good idea to later connect this file to Microsoft Access 2010?
Thanks,