Using Excel as data migration tool; source file paths in a column to new destination

I have been at this for days now trying different methods and pouring through internet for similar questions. All I've come across is paid tools. My predecessor had a workbook that would take a list of file paths of .doc and .pdf files from a sharepoint folder and copy them to a new destination; I know its possible, I just cant figure out how, he deleted the file when he left.

The source file are all in sharepoint. All the .docs are in one folder and all of the .pdfs come from another. We arent moving the whole folder, only those that meet certain criteria. Which is why we are using the excel sheet to capture the files we want to move. We have over 9000 files.

I have the path of each individual .doc file we wish to move in column A and its paired .pdf in column B. All of the .docs will copy to a DOC folder and all of the PDFs will copy to a PDF destination folder.

Please tell me there is an easy macro for this? HELP!

We are only moving files associated with specific content attributes (product, client, etc) so I have to use the list in Column A I cant just filter for pdfs and docs out of source folder.

How would I reference my list in column A and use that for a Macro to say find file in A2 in source location and move to destination then go to A3 and so one.

This is similar to what I've been trying... the only difference I know with sharepoint is I have to use the UNC path format. I think sharepoint is my problem child variable in this. I ran above with a "normal" folder as source with some test data and it worked perfect... when I throw the sharepoint path in there it just spins and errors out.