Greetings Excel friends,

Using Excel 2016, I would like to import 200 pdf docs from 
http://abc/Cred/xxxxxx.pdf
All the file names are numeric text (some start with a zero) and are six digits long.

Is it possible for me to use some kind of import formula to get them?

Thanks for any assistance provided!