Mesh1o,
See if this will get you started. You are going to have to make some modification because I don't know here you files are located. I have this set up so it will loop through 3 appendix files. If you have more, you can simple change the loop to however many it is that you have. You may also need to look at the worksheet names unless your files are using the Sheet1, Sheet2, etc. defaults.
I am giving you a sub and a function. The function simply sees if the file is open and if it is not it opens it.
I hope this helps you get started.
Bookmarks