Macro to move files from one folder to multiple

Hello,

Please take a look at my requirement and help to make it happen, I have a spreadsheet where File, Folder & Subfolder names are available in Column A, B & C respectively. I want the macro to move the files listed in column A to the respective Folder & Subfolder. Also macro should check if the folder & subfolder are available in the destination path, if it is not then the macro should create them and then move. Addition to this the macro should popup a box for the Source path and destination path so that if the locations are changing then there won’t be an issue.

Summary:
1. Prompt for Source location & destination location
2. Check the spreadsheet and create folder and subfolder accordingly and
3. Finally move the respective files to those folders.

Appended is the sample file. Any help is much appreciated. Thank you