I work in an organization where we give people jobs across 3 of our programs. I am trying to create a spreadsheet that can have a master list of all of our participants and which program they are in (A, B, or C) and importing it to another tab in the same spreadsheet where their hours are tracked semi-monthly. We do intake constantly, so new entries are being added and hours are also being added constantly. We want to try to keep the master list alphabetized so it is easier to enter hours.
Here is the problem I am facing. Assuming our destination sheet has names imported and hours entered previously, we run into an issue when adding a new participant in the master sheet and sorting alphabetically- the hours entered for the previously entered participants in the destination sheet do not stick after the sort.
I understand why I am facing this problem, I am just unsure how to fix it. Any advice is appreciated. Please see below for a sample spreadsheet. Note that the numbers are just a placeholder for people's names.