Just to update on the topic, I ended up just recreating the documents in separate tabs of a single Excel file. I then just referenced a single "master list" file of names, etc, from those separate documents and achieved pretty much the effect I was going for.

Thanks for the input!

Cheers!
Joe