Copy column values if data on row 1 has a certain text that is the same in another sheet, then loop through for the rest of the columns

[Hestia]

Hi all

I am still new to Excel VBA as a whole, and would like to seek help from experts regarding a new issue I have.

I would like to copy a column of data from workbook 1 into workbook 2, based on the data it has on row 1.

For example, row 1 of column C in workbook 1 has text called "U.S. Exports to Argentina of Crude Oil (Thousand Barrels)".

I would like to copy the whole column excluding row 1, and paste it in a column of workbook 2 whose first row has "Argentina" only.

Is it alright if anyone could help me with this? I am not sure of how to program this in excel vba.

Thank you for your help!