[PsYcNeT]

Alright here's a fun one.

Lets say I want to create a WFM log for employees, so I create a "Roster" sheet on the first tab. I use the Name Manager to create a Name called "Roster", that refers to column A in the "Roster" sheet. Then, if I use the formula "=ROSTER" in the first column pf every subsequent Sheet, it will show a live update when a new employee is added to the ROSTER tab.

However, if I have formulae (using INDEX+MATCH or otherwise) or data in each row on the other sheets, when a new employee is added to the ROSTER sheet, it bumps the rest down in column A, but all the other columns stay in place.

Ultimately, how do I make it so when an employee is added to the Roster (and ergo added to the =ROSTER reference), it also effectively inserts a new Row in every associated sheet and keeps my formulae intact?