Merging two sheets


I have two sheets
sheet one has names, sales numbers per month, revenue generated per month and a Q1 combined total sales and combined total revenue per quarter.
My dilemma is- can I merge the both by linking them to the accurate names person (without having to do it manually)
Q. How can I then filter it from highest sales number in correlation?