How to Link a cell value with the detailed table

hello ,

can i ask about how can i when i press on a cell value it shows me the value details from the table on the sheet at background.

Thanks with high appreciate for your efforts.

Thanks Mr. Richard Buttrey , for your support, but i mean that how can i when i press on the cell on sheet2 "Just a value" , its show me some thing like pop up Msg or dynamic hyperlink , to show me what is the Number full details as a table like in sheet1.

actually i didn't see some ting like that before , but my manager ask me to make it in a report . so i ask you for your support

i hope that you got my mind .

Try
in C2

=HYPERLINK("# Sheet1! C" & MATCH(B2,Sheet1!C:C,0))