Order summary

Thanks for responding!

This is very close to what I'm looking for!! My only question i have at this point for this solution is if i can get rid of the auto-filter on "Sheet1" after using the macro, as i still need to review all data on this sheet.

An additional inquiry is can i do multiple cells that correlate to the PO "copied" i.e. If i Need to have PO, Salesperson, and Product rather than just the PO cell?

alternatively are there any solutions that do not require macros?

Thank for your help,