Excel 2007 : find <cell reference> and copy to new sheet

Hi all,

Thanks in advance,
I'm pretty new to excel, so forgive me.

I am looking for a formula that will search sheet 1 in column L for a word that is entered into sheet2A1 and copy the matching rows into sheet 2. A 2 and repeat until all of column L is checked.

Hope that makes sense.

Thanks again,
N