Multiple CSV in Folder, Delete Columns based on Header Name for Every File

I have a folder of CSV files. These files each contain columns that are named "First" and "Last"

"First" and "Last" don't always appear in the same place in each CSV file... i.e. "First" is not always Column C, sometimes it's Column D, sometimes it's Column JJ. Same goes for "Last"

I have been struggling to figure out a macro to go through every CSV in the folder and delete the columns based on the name "First" and "Last".

Everything I find from searching online either is for static deletion (i.e. to delete Column J or Columns J:K) or to delete based on the name, but for different worksheets within the same workbook. Whenever I try to combine these two concepts I end up with compile or syntax errors.

Can someone help me with this Macro? Please?

Are you sure that they are really CSV files?

CSV files do not have datas in columns like Excel.

.

Yes, they are Excel CSV files.