Auto Populating into a workbook

[snakel87]

Mr.Excel Experts,

I have a spreadsheet of goals for individual sales reps that i need to put into a simple goal workbook for each rep. Is there a way to auto populate the data? or do i need to manually do each one?
There is a total of 36 reps.

Thanks,

David