Viewing data rows from another worksheet in a portal

[Tracy C]

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:

 

[kevin9999]

Could you share your actual file via Google Drive, Dropbox or similar file sharing platform? Please make sure you make it available to anyone with the link.