I am looking to copy and paste three rows if a cell in
column A = a referenced cell. For example

Column A of Sheet1 has last names
Cell A4 of sheet2 is where a last name is entered by
user
If the last name in A4 matches a last name in
Column A of sheet1 the row the name first appears on
plus the next two rows should be copied to row 100
of Sheet1

I'm not familiar with MVB so any help is greatly
appreciated.

Thanks!