Macro to filter and sort by multiple categories & Send to correct sheet

Hello all,

I have a mock-up of a sheet I regularly use attached. What I cannot seem to achieve in a formula is this:

1. I pull the data from a program
2. paste all data pulled into the 'data pull' sheet
3. manually add filters and filter by year/ product and copy/paste the information to the correct sheet



Thank you in advance for any help you can provide me with!