Pivot Box not Powerful Enough

Hey everyone, thanks in advance for any help you might be able to provide!

I'm working on a project to make my life easier on a daily basis:

Attached is a stripped down version of what I currently use on a daily basis for a recap. The way it works is I copy a ton of data onto a worksheet. Currently I have some "SUMIF" functions going through and figuring out percentages for me which works well, but I have a need to explain certain line items in more detail.

What I would like to figure out how to do is actually copy some of the data from certain rows from the data that has been copied over based on criteria in one or more columns.

For example with the attached file, I would love to be able to have it copy over only data where the discount column is more than $80 and also organizes it by reason code.

A pivot box works well for this but doesn't seem to do everything I need it to do. Maybe I just don't know how to use those well enough and if that is the case, let me know and I'll continue to research that ☺

Hopefully that all makes sense! Once again, thanks for any and all help!