Copy PDF files from one folder to another based on a cell list

Good day guys...

Please help me with my excel file to copy based on a selected list on cell.
If I select A6:A10, then I select Source folder and then Target folder.
the result should be only a cell list that exist will copy pdf file to target folder.

Example:
1. cell A8: 3055704
2. source folder: 3055704-1.pdf & 3055704-2.pdf (3055704*.pdf will copy to target folder)


Thanks,

Thanks for quick reply bro and its work properly.
just some additional and forgot to mentioned from my original post (im sorry for that),
how to make work if the column was filtered?

work great... Thank you very much bro...