Excel File Organization & Tagging

I have a collection of Excel documents that has grown messy over time. I need you to put each file into a logical folder hierarchy and embed an “Author” metadata tag so every spreadsheet is instantly searchable by who created it.

Here’s what I’d like to receive:
• A clear folder structure that groups the spreadsheets in a way that makes sense (for instance by project, department, or any pattern you discover in the data).
• All Excel files updated so the Author field in the document properties is accurately filled in.
• A short summary file—an .xlsx or .csv is fine—listing every filename, its new path, and the Author value you applied.

You may use native Microsoft Excel features, PowerShell, VBA, or any other automation tool you’re comfortable with, as long as the end result matches the criteria above and works on Windows. Accuracy is paramount; I will spot-check several files before signing off.

If this sounds straightforward to you, let me know how soon you can turn it around and what approach you prefer.