So I have this little project that I'd like to start but here's the catch..... 1 file, 30 tabs, 197 line items for 29 tabs. I know wright who wants some of this crap lol

But seriously though I went through the trouble and hand typed them in and the 1st tab that I have is going to be this awesome mish-mash page that has a copy of all the things I want to look at from the other 29 tabs... so in excel lingo I basicly need IF(H3:H200="no") then Copy+paste line item with "no" to cover tab... the Cell range I'm looking at is B3:K200 on 29 different tabs for my line items so I'm kinda stuck at the first part of it making it look in H3:H200 fo "NO" and getting true and fales out of it but I can't make it copy and paste it... or just select the line containing "NO"