如果Sheet 1上的某个列的值= x，我需要将整行复制到新工作表

We are currently using a shared excel workbook to track inventory in a small business. Sheet "Inventory List" lists each product with price, vendor, cost, etc. There is also a column we have created to mark an "x" if we need to order the product. Therefore, if there is an "x" in that column (column E) that whole row would then be copied and pasted into a new sheet. On this new sheet I would like them to be organized by vendor which is column P on Inventory List. Please let me know if you can help. Thank you.We are currently using a shared excel workbook