Word can only use a single flat file as the data source for a mail merge.
You will need to either combine the to sheets into one or create a third
sheet in Excel on which you reference the cells on the other two sheets so
that you have all of the data 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
>I am trying to enter data from two sheets on same worbook in excel, into a
> word document, but I seem to only be able to take data from one sheet. Can
> you help?