I have several payroll worksheets that are named for each specific employee's name. For John Doe the sheet is named Doe.J. When I have a new employee, I add a new sheet, copy/paste a template to the new sheet, I type in the guy's name, change the name of the new worksheet to fit the new employee's name, then I put the new employee on a sheet that is a collection of all employees. The new employee goes to the bottom of the list on the collection sheet. In adjacent cells I have a formula that references the cell on each specific employee's own sheet.
John Doe is at the bottom of the list in cell A25
In B25 is his hire date.
In C25 I have the reference =Doe.J!B$17
Is there a way to do the formula in C25 automatically?