Excel macro to organise files

[seenai]

Hi,

I have some files in a folder. These files to be copied to different folders.

Example :
List of Files in Folder A :

1. 20170725_011111_G113_17_ACC.pdf
2. 20171125_001011_I002_17_ACC.pdf

List of Folders in Folder B :

1. 001011_InternalMicrometer
2. 011111_ExternalMicrometer
3. 011131_ExternalMicrometer

I need an Excel macro to copy the files as below :

1. Copy file ‘20170725_011111_G113_17_ACC.pdf’ to folder ‘011111_ExternalMicrometer‘ (Text between first _ to second _ is to be searched in folder names for copying)
2. Copy file ‘20171125_001011_I002_17_ACC.pdf’ to folder ‘001011_InternalMicrometer’ (Text between first _ to second _ is to be searched in folder names for copying)

Thanks in advance

Srinivasa Rao