Excel 2007 Linking & Formula Update

I have an attendance sheet that I need to copy for 400 employees. I have linked it to database that I imported and filtered. I am only extracting name, id, fte and hire date. On my timesheet tab I am copying and pasting a new sheet for each employee, but when I copy a new sheet, the formula updates by linking to the new position based on copied/pasted line, instead I want a formula to pick up next employee and each one after. See attached (i.e., look in formula bar on the record I'ved copied, and see how it reads ='Employee List'!$F51, instead I need it to pick up ='Employee List'!F3, then on the next copied timesheet, ='Employee List'!F4. But instead it grabs whatever line I start on. What is a way to do this? Also is there an easier way than copying 400 employee timesheets (every 50 lines), than what I'm doing?

 

Thank you for your prompt response. I will try to write a macro that will copy each sheet as suggested. Even though I am working in 2007 I save my files in xls because some of the people that will need to access this report still have Excel 2003, and no compability on their computers so I always save in this to ensure opening.

 

Of course I desparately need help, even with writing the macro, as I have been researching a resolution for this for about a week or so. But I'm learning everyday as I encounter new challenges. I generally go online & find youtube and Lynda.com examples, but I'm stuck so far which is why I entered the forum.

 

Just make sure it is always 49 rows apart.

 

With macro filling.

 

From his example, he is listing all in one sheet.
I doubt he wants to manage 400 tabs.