If you are using Word 2002 or 2003, you should be able to choose a specific
sheet.
If you are using Word 2000 or earlier, you will only be able to use a
particular sheet if you
a. check "Select method" in the "Open Data Source" dialog box
b. choose the ODBC or Converter connection method to get the data from
Excel, not the DDE method (which is the method Word 2000 uses by default).
Is that what you meant by "using just individual sheets" ?