Suppose that I have 100 stocks which update every day, or so. I can
easily (using manual methods, which I don't mind) cut and paste the
symbols of these 100 stocks every week.

Example:
SHLM
IOSP
LFUS
ASEI
KAMN
GIFI

However, I'm also interested in tabulating their Analyst's Ratings from
the following website:
http://finance.yahoo.com/q/ao?s=SHLM for the first stock with
symbol SHLM.

How do I automate the process of parsing information from websites
like:
http://finance.yahoo.com/q/ao?s=IOSP
http://finance.yahoo.com/q/ao?s=SHLM
http://finance.yahoo.com/q/ao?s=LFUS
http://finance.yahoo.com/q/ao?s=ASEI ?

I know how to parse the desired information by importing data, but the
downfall with this is that I have to create a new query for every stock
symbol. I don't want to do it this way, because I always put in
~100-200 new stock symbols every other day.

I think that the better way to do this is to concatenate the website
addresses as: http://finance.yahoo.com/q/ao?s= (which is found in Cell
$a$99) + "STOCK SYMBOL" (which is found in cell A2). On that
particular website, parse the needed information in the dialog box,
which happens to be 3.0 for IOSP.