I have a question that I have searched high and low for an answer to and have had no luck. I feel like this is not a complicated issue, but I have not been able to find any information.

I am trying to create a monthly tracking workbook for work with a tab for each month with every employee listed on each sheet. Staff turnover is high, so I need to be able to update a Master sheet of staff names (frequently adding and deleting rows) that will update the subpages for each month with the changing list of staff names. Pasting linked data from the Master sheet into each cell will not work since rows will constantly be added and deleted.

I am sorry if this has been asked before, I did a lot of searching regarding Master sheets and Templates and came up empty handed. I am looking for the simplest solution to this problem – if someone could point me in the right direction, or any advice at all really, I would be extremely grateful!