Automation question - Running change

[Yerko_Begic]

I would like to run Automation every week on Sunday, and the purpose is to have a running change for my Pivot Tables. I would like to take the "Items", "QTY" and "Last Date/Time Updated" from Table1, and copy/ paste that data into the Table2 which has the same column names. Is this possible and how is it done? I was poking around and wasn't able to figure it out.

[TheTimeSavingCo]

Could you provide some screenshots of how the data looks in Table 1 and your expected output in Table 2?

[Yerko_Begic]

Here is my Table1

And here Table2

I would create PivotTable based on Table2 to track my weekly/ monthly/ yearly data 

[Yerko_Begic]

Let me correct one thing... There are going to be other columns in Table1, but I only need "Items", "QTY", "Last Date/Time Updated" and "Value" to be grabbed and moved over to Table2

[Yerko_Begic · Accepted solution]

as able to solve my problem with the Java Script.