Copy rows to another sheet base on text in cells

It would help if you attached a sample Excel workbook, in which you can indicate what you want to achieve.

Pete

Hi Pete_UK,

Thanks for quick response please find below before(Brown) and after(Green) sample.

Just need the best way to produce this ideally "After" needs to be on separate sheet tab part number sorted with print range to suit

As requested this is just a sample of a very big spreadsheet

Please let me know if you need any more info

Regards

WOB