Hello - I am very new to VBA/macros etc.

I work in a sales role and am looking to automate a daily process of figuring out, based on the various stock tickers that come up in the day, which clients will be interested.

Right now I have an excel file - with each sheet a different account, and on each of those with a list of the contacts in each of those accounts, and their stocks of interest (tickers of interest all listed in one cell to the right of each contact name like this....AAPL; QCOM; HPQ etc).

I want to write something that allows me to type in/identify a ticker, or ticker(s)...and then have the program run through the sheets looking for a match to that/those tickers.
When the match is found I want to make a copy of the whole row in which the match is located, and pull it into a list on a new sheet...thereby aggregating all the names relevant across all accounts into a list for a given ticker.

Any help/guidance on how to go about this would be much appreciated...I think this will make things much more efficient!