Filtering rows by cell value

New to Excel but trying to put this together for work. I’m trying make a table where each row is an invoice line item, but I need to remove/hide any items on invoices containing labor. Column 1 is Category with Labor, Parts, etc. and tab 4 is invoice number. I want to single out line items with labor in tab 1 and collapse all lines with the same invoice number so it only shows items from invoices without labor. Is there a function or chain of functions that could do that?