I have to admit I'm really an excel rookie, but I gave this my best shot.

sales customer thing.xlsx

I've been attempting to summarize a sheet of data in a table on the 3rd sheet. I'm using a drop down menu to change the table based on the row title the drop down menu is selecting. I also have no idea how to pull the data from the other sheet, and I've really tried everything. I'm a rookie, so that's why I'm coming here for help

I've attached the file and I'd love for someone to guide me through the steps to fix it so that I can learn from what I'm doing wrong and work through this.

I've tried VBA macros, but they were so far out of my league that I got frustrated and switched back to attempting to solve the problem with =lookup() functions and h/vlookup (to no avail).

As you can see, on sheet 3 I've got a table that is trying to find the top 5 products by weight that were sold to each individual customer. The table should auto fill the values based on what is selected in the drop down menu. I also wanted them organized in ascending order, so I did that with =Large() function.

However, I want to also be able to pull the name of the products that these values are for, and if they're 0 then it should be blank. For instance, if 1000lbs of something was sold, I tried to get it to say 1000 lbs of Brass tube 464, or whatever is applicable.

*Note - I know it lists GP and such, but I haven't made input the rest of the sheets yet, so If there's also a formula I could use to look up another sheet's gross profit values, that'd be awesome.