So the slightly tricky part is that the files you're dealing with are PDF files. They're not the easiest of files to deal with - it's not impossible, but it all depends on what it is that you want to do.
Is there a way to create a list of files in a folder including subfolders and then display the title/description and Author?
As for this part of the question, yes - it is easy to produce a list of files in a folder (including subfolders, and the files contained therein). You already note in your explanation that you know that are ways of doing it, but if you don't have any code to-hand, it's easy enough to find in this forum or online. But then you're asking two different things - here you say that you want to display the title, description and the author details, but in the next sentence you say that you actually want to edit the metadata.
Displaying the details (to the extent that the info is contained in the PDF file) is doable, though from memory it hasn't always been 100% reliable. I may be misremembering. As for editing the PDF metadata, though, I actually don't know of an easy way to do that off-the-top of my head without relying on a third-party library, such as Adobe. You could conceivably load the PDF file into Word, adjust the key properties, and then save that as a new PDF file, but it's a bit of hassle and it can throw off the formatting of the original PDF.
When you say you've been doing it manually, how have you been doing it? It may be the case that you have a license to PDF editing software already that VBA can automate.
