Multiple users saving data to a single file
 

Our company has multiple users who store their personal
data in their own personal Excel files. Occasionally, users
will need to copy some Excel data from their workbooks and
paste it into a Word document that is shared by everyone.

Rather than having everyone copy their Excel data, then
paste it into the common/shared Word file, wouldn't it make
sense to create a macro in everyone's Excel workbooks
that can automatically transfer a row of Excel data into
the shared Word file??? Does this seem like a feasible
solution??? Are there any pitfalls that could ruin this idea??
Can anyone think of any better solutions??? I would really
appreciate ANY thoughts or ideas regarding this.

Thank you!

Robert Crandal