In that case, it seems to me the real issue is that you want to avoid having to copy the master list into your main document, run the macro, then cut & paste the result into the Appendix document. Instead, it seems you want to run the macro from another document, say, the master list document (which would have to be a .doc or .docm file, not a .docx file), but with the result being saved to either a new document (which becomes the Appendix document) or to an existing Appendix document.

Presumably, you wouldn't want to macro to change your master list?

Obviously, the process for creating a new Appendix document would be different from the process for adding the table to an existing Appendix document, so you'd need to decide which of those approaches you want to take.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]