Viewing data rows from another worksheet in a portal

First off, I'm a novice with Excel. Learning by exploring. I have a worksheet (#1) with 14K+ rows of data (30+ columns). One of the columns on sheet#1 holds a unique ID number for each row. On another sheet (#2) I have 72K+ rows (20+ columns) of data where multiple rows have the same ID# on sheet#1 (where there is only one unique ID field for each row). What I'm trying to do is to be able to view the set of data rows from sheet#2 onto sheet#1 when I click into a certain ID# on sheet#1. Then when I click an ID# of another row, the related data set updates with the rows related from sheet#2. Does this make sense? Any help will be appreciated. In the meantime, I'll keep experimenting. Thanks!

Here are some screenshots:
1.jpg2.jpg3.jpg

You don't need to ask an Administrator - Moderators can do the job. I have moved the thread.

It's here.

https://www.excelforum.com/excel-pro...-a-portal.html