[Solved]Complex Filtering & Copying With VBA (Need Help)

[Nctukek]

Hey All,

I am attempting to create a sort of complex selection system with VBA and could really use some help. The primary goal I am trying to achieve(there are a couple of filters I need to create) is to find the most recent order # a certain customer is mentioned so that I can copy some information from that particular line into a sort of summary sheet. The information I am filtering through is spread over multiple tabs which adds another level of complexity. I'm relatively new to VBA so this is particularly daunting to me as I am not very familiar with the syntax.

I have attached an example of what I would like the end result to look like to this post, please let me know if you have any questions. Any advice on coding and syntax to achieve this would be great.

VBA Filter+Summary Example.zip

Thanks for your help!
-Nctukek