Making an Excel Stock Screener or Stock Tracker that grabs data from the Web?

Hi everyone!

I know the the basics when it comes to Excel, but what areas of expertise would I need to learn if I want to create a personalized stock screener or stock tracker that can display all the up to date data automatically or with a simple click of a button?

An excel sheet that automatically grabs market data from web sites or pdf, and fills them into the right cells for display or calculations.

Doing this manually for each stock has really taken a toll on me, so I was wondering if there's a way I can automate this painstaking process.

I have a degree in Computer Science, so even if I have to learn VBA it shouldn't be too much of a problem- however, could someone point me in the right direction? If so, is there a resource online you would recommend? A tutorial or video that covers the subject really well?

Thanks in advance.