Collation of information onto one page

Hi again

I would like to tidy up the amount of spreadsheets I currently keep in regards to the HR part of my job.

I have found a Excel template which will collate all the attendance (holidays, sick etc.) however I would like the main sheet to be able to show other staff related information I keep,
For example, when I select the relevant staff member from the drop down list is there a way for the sheet to not only show the attendance figures but also a employee information start date, contact details and so on.

I have attached a copy of the template i have found but not sure how to incorporate the other information, if possible?

Thanks in advance