How do I automatically copy data from Table 3 to a new column in another table while maintaining static values?

I have a team that I update data for every day in Table 1. I get that data from someone else formatted in an UGLY WAY and they aren't going to change their format so I created Table 3 to be in the format that I like.

With each column it represents a different kind of data and for each column I have additional "sheets" in Numbers where I manipulate the data. The important thing to know is that the data in Table 1 gets updated EVERY DAY and Table 3 points to Table 1 so it ALSO is updated every day.

In a different sheet I have Table "Compared to next closest player" which obviously (see below) notes how close/far each player is compared to the next closest player for each and every day (as below).

I know how to MANUALLY copy the stats in Column 1 for Table 3 into a different table, Table "Compared to next closest player" which is on a different sheet so that data is static. But I don't know how to add a new column and have it automatically copy the data from Column 1 in Table 3 into the new Column in Table "Compared to next closest player". Note that the Date and the number automatically adds "1" to rows 1 & 2 so I don't need help with that. I just need help to find a way to automatically have the data from Table 3 Column 1 put into the new Column on "Compared to next closest player".

I have a BUNCH of these so any help in automating it will literally save me more than an hour.

Hopefully that makes sense.

[Re-Titled by Moderator]

Original Title: Table 3 gets overwritten each day with new data for that day. I need to copy the cells from Table 3 to another table where I add one column for each day and I need that data to be static on that other table.