You can't get all 5 together.  However, you may be able to join the 5 sheets as is each were a table.  I don't really work with Excel as a data source, so I'm not absolutely certain about this, but it would make sense.  The thing is that Crystal needs to know how to join the sheets together in order to get data from multiple sheets.  In the Database Expert go to the Links tab.  Designate one sheet as the "Master" and link from it to each of the other sheets by dragging a line from the appropriate "field" in the master to the matching field in each of the "children".