Opening and editing mutiple csv files

[Chunk]

Looking for help.
I am fairly new to VBA and am trying to accomplish the following:

I have multiple csv files (up to 80) in a central location, that I need to open and possibly edit (by deleting column "A" if it has "FileName" in "A1").

I then need to rename the file to be able to use it in another application.
An example of the file name that I receive is:

PPS_PROJECT1_F18_January_XXX_10JAN2018.csv

I need it to be renamed (using the Main workbook for the conversion):

POA01_Q1_10JAN18.csv

I am using Main workbook to initiate the conversion and hold the lookup list for the projects.

Attached are 4 example files (3 that need the first column deleted and one that does not) That I receive and the Main workbook.

Any help/tie yo can give is greatly appreciated. Please let me know if you require more information.

Sincerely,

Chunk