mousing over a cell to see contents from another sheet

I have two excel sheets/tabs. One is labeled "names" and contains a list of names, the other is labeled "details" and has the same list of names (in a different order), as well as an age and color in the same row as the name.
Is there a way that I can write a comment or hyperlink (or any other type) code that will work such that, if I scroll over or click (for example) the name "Samantha" in the names sheet, the code will extrapolate from the details sheet and display the information in the same row as the name "Samantha", such as "29, Purple", without redirecting to any other cell.
Thanks!

Originally Posted by mehmetcik

You could easily do that with a userform.

Could you possibly explain this more in depth?
Thanks!

Thank you so much! I just have one more question,
A new spread sheet I have has multiple columns in the names section labeled

mother, father, name, sister,

the second sheet is still the name, with one name corresponding to a color and birthday.
However I also have a third sheet now called "sibling", that also has a color and a number.

How can I edit the code so that if I click on a name in the row "name" it extrapolates from the "details" tab, and if I click on a name in the row "sister" it will extrapolate from the "sibling" tab and give me the information.

Additionally, nothing should happen if I click the mother or father tab, as they have no corresponding cells in the other sheets.
thank you so much!!