Method to search other sheets in a workbook for a unique row

First off, I'm a server administrator and a complete imbecile at Excel. However I need to learn it to help track my hardware inventory.

My problem is basic. My workbook contains a input sheet and multiple sheets with the data I compile. In the examples I provided, on each sheet "Server Name" is unique data to each sheet. I would like to have the ability on the Input sheet to click one of the server names and that take the user to the record on sheet 2. Not sure iif I need to be looking at a Macro or a formula to do this. Could anyone please advise?

Thanks