Rename and move files to a prespecified location

Dear all,

I want to be able to rename some files (of different formats: xls, pdf, dwg, dgn...etc...) to an already created folder structure.

I receive an excel sheet (see attachment) along with the documents i receive. I want to have a template excel with a macro that does the following:

1. I firstly copy-paste the information shown in the excel I attached, to the new template excel with the macro.
2. The files are named as stated in cell A (i.e. 483-21-DT-M-00300-Ed001.pdf) but i want to rename them as follows:

"Cell E" & "space" & "Rev." & "Cell C" & "space" & "(" & "Cell F" & ")"

3. When the files are physically renamed, then they should be moved to the location (network drive) as it is shown in cell G BUT instead of PROJECT_483, this should be replaced with W:\GR-IPP_II\02.*Engineering
4. In case a file misses an information (i.e. cell E or F is left blank) a "-" should be placed in the file name and then it shall be moved to the path.

in the above example the 483-21-DT-M-00300-Ed001.pdf will be renamed as 111915-21-YDS-MDD-EA-00300 REV.1 (P&ID SYMBOLOGY AND GENERAL NOTES).pdf and the path shall be: W:\GR-IPP_II\02.*Engineering\200 Mechanical Area\221 Systems\221.01 P&IDs\111915-21-YDS-MDD-EA-00300 REV.1 (P&ID SYMBOLOGY AND GENERAL NOTES).pdf

Thank you in advance!

I am sorry if i misled. I receive everyday a csv file with the actual files listed in the excel and with the information as shown in the attached file. I need to have the files to change their names (as stated above) and then moved to the path as shown in the last column (with the change to the correct directory)

I want to do all that to an xlsm file, so i need to copy-paste the information of the csv everyday i receive a new one. I haven't used VBA for ever and i am stuck!

I am not trying to change the name in the excel, but at the actual files.
To do that i need to collect the information from the cells "Cell E" & "space" & "Rev." & "Cell C" & "space" & "(" & "Cell F" & ")"

Then the path to move them, is half stated in the last column so it needs to be correctly created since the directory's folder structure is already there