Forum Discussion
Tables, Multiple Tabs and Sorting
Make sure the employee numbers on the month sheets are inputs, not formulas. Then use the XLOOKUP function to retrieve the other information of an employee in the other A-E columns. Now if you sort the master list, the month sheets are unaffected. You do have to manually add a new employee to all month sheets this way however.
Thank you for responding but that does not solve my problem. I will presume there is no way to keep all the rows synced while using the master list to keep employee updated in each month. The goal is to add employees in the master sheet so that all months are updated with the correct employee and then ensure that each row in reach month stays connected or synced to the employee when the data for each month is entered.