Excel Time Tracking Help

Hello,
My question is that I have a Excel workbook that I want to get information from a cell in worksheet 1 for a specific date to go to a cell in workbook 2 for that specific date as well. This is being used as a yearly attendance workbook. In worksheet 1 it will track it will track their hours worked, sick time, vacation time, overtime, holidays. In worksheet 2 it will track their yearly record of vacation time, sick time, & holidays time off, so at the end of the year or someone asks how much time they have left we can just open this workbook and get that information for them. Thanks