Use of multi. databases in a mail merge

[S. Marshall]

In a mail merge document I am trying to use several
worksheets withing the same database to pull information
from to do a mail merge. My columns have titles but in
mail merge it only recognizes the first worksheet in the
database and no other to pull data from. When I open the
database in mail merge it asks if I want to open the
entire database and I answer yes but it still does not
give me access to all my data. What do I need to do
differently to access more than one data source?