So the directory the files are in changes?

If all the files are in the same directory you could declare the path as a constant.

You would do this at the top of the code, and that's the only place it would need to be changed in the future.

By the way, why not close each workbook you are opening once you've finished with it rather than closing them all at the end?