vba problem copy paste and email

can anybody Please help with the problem I have - I have got the work book to run fine it does what I wanted but now I have to send a copy via e-mail but I don't want to send all the work book just the copyreport sheet. (I have added some sample data to the form (if you click the enter the sheet will transfer info over if this happens just put any info in it)) is it possible to select the 'copyreport' sheet - open a new work book - remove sheet 2 and 3 - paste the info into sheet 1 - then save the new work book as the date(this will the date the report was raised) - then e-mail the new work off - then close the new work book. I know this is a big ask so any help would be much appreciated....