VBA that skips a cell if condition is not met otherwise look for next cell

I'm a full on Beginner with VBA and was hoping to solve an issue at work. I have a raw datasheet in the first tab with Invoice numbers and if they have ( quarter number and a year) or have not been paid (empty cell). I want to grab only the unpaid invoice numbers (or even better the whole row) to second sheet. Because there are couple thousand rows, I can't just use an if statement and then sort and delete the rows that have been paid. Is there a way to only show the the wanted information?