Transfer Files to sub-folders

Good day everyone,


Help me with this please....
I have folder [Temp] where all scanned files save.
All i want is to transfer inside folder [Attachment] in designated folder based on
sheet(MasterList) details.

Example: 100001 & 100007 will transfer to folder [Attachment] inside folder [7593],
only the existing files inside [Temp] will transfer that matched based on the sheet[MasterList].
Just in case supplier folder inside [Attachment] is/are not exist then it will be created automatically.

Im just doing this manually by opening pdf one by one and checking supplier# then move to designated folder.

See attached file for additional info...


Thank you,

Someone help me please... need code modification to make it work...

Current status
1. 1st click nothing happen, 2nd click it worked...
2. only the pdf files copied inside folder [Attachment] with existing supplier folder

all i need now is all existing pdf files inside folder[Temp] without supplier folder inside folder[Attachment]
will create folder automatically based on the supplier#...