No, Word can only use a single flat file as the data source. You will
therefore need to add a third sheet to your file on which you reference the
data on the other two sheets so that it all appears in the one place.

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
> Is it possible to select multiple worksheets in the same workbook when
> specifying the data source?