I am looking to create a revision log for a group of files in a folder, the number of files always changes it could be 2, it could be 20. In each file the name of the item is in cell C12 (could be A-3, A-7, B-3, anything with a letter then a number) and then in cell C9 the revision number is located. I am looking to make a macro which creates a list of 2 columns, that says the item name and revision number.

Thank you so much for your help!