Posted on the chat thread, bringing it to a different thread for visibility...
Columns A and B are employee numbers and names; I want them the same across all worksheets (currently have one worksheet for every month, as well as a YTD sheet)
Columns C-EM are daily and weekly summary cells that tie to individual employees.
How can I make it so I can add a new employee in, say, March and have it add that line and keep everyone's data with them across all the other sheets? As of right now I can get it to add the employee (I made columns A and B "table1" in January, and have all the rest of the month sheets reference =table1 in columns A and B) but can't get it to move people's data with them. The other ways I tried brought ALL the data, not just the formulas, which screwed up each individual months' entries.