Data not sorting or flowing correctly

I have a file that uses a master tab to feed data into other tabs. In the master tab, managers are responsible for logging the total hours an employee worked in a 4 week span (WK1-WK4). The manager must then go into the separate weekly tabs and log the total hours the employee logged each day for that given week. So far I’ve found a few issues: my data is feeding properly to the broken out tabs, but I am unable to filter the data in the breakout tabs because I am getting an array error. Also, if I already have logged employee hour data in the weekly breakout tabs and then add a new employee the data inputs for employees already on the sheet are not flowing to the correct line if someone is bumped down a row (IE the breakout data stays where it was originally input and will not flow with the persons name). Ideally if a new employee is added to the master tab they are auto sorted in alphabetical order by Office then Last name and then that sorting is also done on the broken out tab. Additionally, when a new person is added the data already entered into the broken out tabs realigns with the correct person automatically without a refresh or re-sort. Please help if this makes sense!