Multiple spreadsheet in email

Hi

I have to send around 40 emails to different people each week, in each week have to put 1 page of a spreadsheet - different for each person is there any easy way to do it. The overall objective is to share each persons sales figures with them but not with anyone else and a shared message that is the main body of the email.

I have been copy and pasting each one into each email but it takes forever and it's a brain drain boring job, any ideas?

Thanks.