i am a stock analyst.

(sheet 1) i watch live market in an excel sheet. developed a micro to sort
the data using some criteria. run the macro automatically every 5 seconds.

(sheet 2) contains my model portfolio with desired entry price.

seek assistance to link the above sheets. macro should compare the 1st row
of (sheet 1) with all the rows of (sheet 2). For example if ABB appears in
the 1st row, macro should go and search in (sheet 2) and see if ABB is part
of the model portfolio and the current price is below the desired entry price.

Should ABB be present in (sheet 2) and the current price is below the
desired entry price then it should be recorded in (sheet 3)