I have pulled together a lot of product information for various KVM products on the market. What I am trying to do is pull product information from the 'Data' tab, and have it displayed on the Product Comparison tab. The plan is to be able to compare up to four products on the product Comparison tab at any given time.

I want to use a dropdown menu that will show each Part Number (on the Product Comparison tab), and when you click on that P/N #, it populates all of that parts data from Data tab. Example, if you click on F1DA104Z under Product 1, it will populates the Product Comparison tab with cells B2 through B65 from the Data tab. I need to do this for each P/N # on the Data tab (in total I have 338 I need to do this to).

What is the best way to do this, and is it possible to have the dropdown of Part Numbers be categorized so they are easier to understand for others besides myself. An example of the dropdown structure I'd like to use is shown below. My plan would be that no data is shown if you click on the Company Name or Category from the dropdown menu *they are just placeholders*, but instead...data is only populated when the Part Number is selected.

Company Name
KVM Category
Part Number 1
Part Number 2
etc. etc.

Please let me know if there is any easier way to achieve this. I just need a push in the right direction, and I should be able to replicate it across all of the different Part Numbers.

Thanks in advance!

Data Example.xlsx