Sending multiple sheets as one attachment


Hi All,

Is it possible to send multiple sheets (all in the same workspace) as an attachment? 

The reason I ask is I have 8 reports which will all need to be sent on the same day each month and I was hoping to avoid having the the client recieve 8 emails each time. Pdf of excel is fine

Thanks, Soph