|
There must be a script you can run through some language that would add the folder name to the file name. Then in excel you can lookup a certain location based on a file name that changes by year. I've done it before with OOTP data and used some mass file renaming software to do it. But there has to be a way to automate it.
|