Macro to search column and paste row

[sieira67]

So I've been trying to put together a code in VBA that will search column A from A1 to A500 for different words (i.e. Mason, Electric, HVAC) and then copy and paste that row in a desired location on a different sheet. The way I've been doing it is much to complicated and I KNOW there is an easier way to do this.

Figuratively, I would like it to run like this

Range A1:A500

If A1 is Mason then copy & paste row into row 2 of sheet 2.
Else If A1 is Electric then copy & paste row into row 5 of sheet 2
Else if A1 is HVAC then copy & paste row into row 10 of sheet 2
,,,, and so on for the other words I need filtered.

I also need the program to know to move down a space on the second sheet so that there it wont overlap with the other pasted rows.

Thanks for the help