How do I duplicate column data from one table to another without VBA?

The suitable solution will depend entirely on how you propose using the two tables. What is the reason for the duplication of data?

There are instructions at the top of the page explaining how to attach your sample workbook.

Thanks for the initial feedback. My ultimate purpose for this table is to have a "master" table that will contain select columns that I will get from other worksheets, with the Record ID as my unique key.

For example, on the attached file, my Sheet2 will contain these merged data. But what I want to happen is, whenever the Sheet1 table is updated, I want the Record ID column on the Sheet2 table to be updated, so that the rest of the columns will get updated using index match expressions.

In production, what I want to do is on a regular basis, I will just download the latest copy of csv data files in one folder, and once I open this Excel file, I will just need to do a refresh and the merged table will be automatically updated with the data coming from the latest csv files.

Hoping my explanation is clearer now

Still not 100% clear - sorry.

Can you explain the workflow for ONE record ID so that I can understand the changes that might occur? How is the secondary table to be used? Your example workbook is too simplified to tell the whole story, I fear.