google sheets – Using an ID to access data about an individual across tabs in a spreadsheet

If I have a unique ID # next to a name on multiple tabs of a spreadsheet (with each tab having different types of data), how can I bring it all together. For example, if I have a protected sheet at the beginning of my spreadsheet that serves as a dashboard, how can my client select the ID or name and have all of the data pertaining to the individual show up?