I'm not sure what this would entail but is there a way to fix our summary
pages to include formulas or whatever that more automatically update links
from the sheets linked to them when new sheets are added to each workbook?

The reason I ask is because my colleagues are dealing with four workbooks
that each have about 15 worksheets minimum. Every time a new employee is
hired, a new employee sheet is created by copying one from another employee
and modifying the entries to reflect the new person. Unfortunately, the
summary sheet doesn't automatically include working links when they copy a
row on the summary sheet to a new row created for a new employee. They must
go into every single cell on that new row for every single new employee, if
I've understood correctly, and update the cell manually to put in the
correct sheet label, etc.

Is there any way to make this easier for my colleagues so they can do this
with less fuss and muss?

(I've tried to be clear as I know how, but if it isn't, pls advise and I'll
try again.)

Thank you in advance! :oD