How to automate copying dynamic data from Table 3 into static rows for each player in Table 'Top Players' using MacOS?

I have Table 3 which gets overwritten every day. Each player has a group of rows that are stacked on top of each other. Gerald, for instance, currently has rows 2 through 51 in Table "Top Players". And tomorrow I want to add a row to Gerald's section would be row 52 and then copy and paste the data from Table 3 into Row 52 as Static data so that row 52 will always have the same values while Table 3 does not. Hopefully that makes sense. And each player needs to have a row added in their section.

Does that make sense? Is that possible with numbers? Does automation in MacOS help with this or not if it can't be done within Numbers. Or something else without having to program something in C or Swift or anything else.

[Re-Titled by Moderator]

Original Title: I need to copy NON-static data EVERY DAY from Table 3 to Table "Top Players" but Gerald currently has rows 2 through 51, Bob from 52 through 70 and so on. And then tomorrow each has one more row with static data.