VBA code that finds data based on criteria, moves up two rows, copies cell to new sheet

Hi guys,

I have a sheet which will constantly be changing. The sheet lists users and the users I need can be determined by a specific row that is 2 rows below their ID.

Basically what I need is a VB script that will perform a find command for a specific phrase. Once it finds that phrase it will move up two rows (where the id is located), copy the data from that cell, paste it into the next cell on a second sheet, and then return to sheet one and continue performing the find command for the next instance of that specific phrase (skipping the one it just found before moving up 2 cells).

As an example lets say the phrase is "This user" If the sheet were broken out like it is below, I basically need sheet2 to list Ryan, Aaron, and Mike on seperate rows (e.g. A1, B1, C1 on sheet2). Any help you can provide would be greatly appreciated.

Ryan
Ab1
This User
True

Bob
Ab2
Not Him
True

Aaron
Ab3
This User
False

Eric
Ab4
Orange
True

Mike
Ab5
This User
True

Thank you alphafrog, I'll have to try this tomorrow and see if it does the trick. I really appreciate your help.