The attached workbook should contain the functionality you're looking for. Adjust the path name in B1 as needed, and it should be ready to go. Whenever you run it, it will add any new document names that it finds (not already in the Documents sheet) to the end of column A. You just need to then add the description, date, etc. I don't take credit for the code that searches the folder for file names. I found it on the internet. Have fun!
ManageDocs.xlsm
Bookmarks