Is there a way to auto-populate info from a spreadsheet that contains a weekly summary of hours worked for all employees to a spreadsheet that contains a weekly summary of hours worked for individual employees? The spreadsheet (summary of hours worked for everyone) is in one workbook and the time card (summary of hours work for each individual) is in another work book. In the end, I would like info that is inputted in the summary worksheet of all employees to be auto populated into the correct individual time cards. Can provide more specific information if needed

I feel like I tried everything I need help!