Making A Hyperlink in a Cell

[sohaillasi]

Hi all,


I am making a Human Resource Pay Roll in MS EXCELL 2013,

I want a Drop Down List of all the Employees ID's in it and when I select one ID from that list it should go to the corresponding Employees Time Sheet which is prepared on the same work book but on different sheet