Copy Multiple Rows Based on Values

I have searched through some other threads and found similar problems. I actually found one thread that was trying to do the same exact thing as me but I could not get it to work, and I was hoping someone might be able to help me figure out why.

I have a spreadsheet where I am inputting a report into one sheet and I want a formula that will pull all rows that match the criteria (in this case, the name of a project manager, which is one of the columns of data in the report). I've attached a copy of my spreadsheet, plus a copy of one that aims to do the same thing (and does it successfully). I just can't understand what is wrong with my formula. I want to copy only the information from rows A:G

The line of code that worked on the other spreadsheet was as follows (this is what I'm having trouble getting to work for mine):

{=IF(ROWS($A$1:$A2)>COUNTIF(Main!$C$2:$C$28,"Mike"),"",INDEX(Main!$B$2:$B$28,SMALL(IF(Main!$C$2:$C$28="Mike",ROW(Main!$C$2:$C$28)-ROW(Main!$C$2)+1),ROWS($A$1:$A2))))}

Thanks!!!

Mike