I have a table with 5 columns and the 3rd column is blank (if that matters)

the 5th column has a value of eith A or B.

I want to find all the rows where the 5th column is B and paste the ENTIRE ROW tino a new worksheet and continue doing this until all the rows where the 5th column is B is in that new worksheet.

Could someone please help?