Auto-Enter list into cell and record if cell meets various criteria automatically?

I'll try to explain the situation. I have a stock valuation spreadsheet that looks at a number of different factors to determine a companies value. If it satisfies certain criteria (such as having positive cash flow or a strong return on equity), it becomes a stock that I would consider purchasing.

When I enter a stock symbol in a cell, it automatically pulls the financial information from the internet so i can look at the specific criteria.

I'm trying to automate this process.

I'm trying to provide a list of stock ticker symbols. These ticker symbols would be fed 1 by 1 into the cell that pulls the financial information. The information is pulled in 1by1, the results are examined, and then those ticker symbols are set aside and the next ticker is pulled in.

Is this possible?

For example,

List of symbols - A2:A10

Ticker Input - Cell B2

Criteria - J18>10%, K13>10%, K11>0 etc etc.

If all 3 criteria are satisfied, then the ticker in B2 is set aside in a separate list and the next ticker symbol on the list is entered into B2.

I would like to be able to change the number of symbols in the list as well as the amount and variables in the criteria.

Keep in mind, there is sometimes a 30 sec lag time before the financial information is pulled into the spreadsheet...so there would have to be a lag before the actual #'s are in the worksheet to see if they meet the criteria.

I hope I am explaining my questions...This would be a HUGE help if anyone could help me with this...I'm not sure if VBA or Macros would are the answer but I would appreciate any input.

-DrSues02