Is there a way to send multiple sheets in one email?
You cannot send multiple sheets in one email but you want to send data from multiple sheets, you could use reports to pull data from multiple sheets then send the report via email. Here is information on reporting: http://help.smartsheet.com/customer/portal/articles/522214-creating-reports