How to keep previous cell values ​​in neighboring cells?

Question

Google Sheets

There are two sheets.
1 - sheet for data analysis from the second sheet. I collect data using VLOOKUP.
2 - sheet with data. They are updated periodically.

Each time before updating the data of 2 sheets, I duplicate the data with formulas in new columns. And I copy the columns from the previous period and paste only the values ​​\u200b\u200b(to get rid of the formulas).

How can this be automated as much as possible?

Answer 1

Using Google Apps Script, you can automate this as much as possible.