Email Excel worksheets to multiple people per tab

[cooket4]

Hi

Every month we produce accounts for all the cost centres and I have a macro that emails each tab in the workbook to the specific email address on the sheet, 1 per cost centre.

Now there is going to be 2 sheets (one data and the other graphs) for 1 cost centre. While my macro will still work, it will sent 2 emails to each cost centre. But people higher up don't want that, they want both data and graph sheets to be attached on 1 email.

They are wanting this done in the next few days. I have no idea how to do this and really don't want to go back to manually as there are over 200 cost centres!

The code I have for sending the individual tabs out is:

Any help on this will be appreciated

Thank You

[cooket4]

Sorry for got to add

An example of the sheets would be CC1 and CC1 Graph etc

I don't know if it is possible