It is obvious that I don't have a good understanding of how your workbooks are set up within each directory, and I have already spent several hours on this, so I am going to pass on this thread. Maybe someone else will pick up on it and give it a try. Sorry I couldn't resolve the issue for you.
Regards, JLG