VbA code to copy data from one workbook to another

[Derek]

Hi All

I have data present in "Date" sheet of Workbook1. Now I have another workbook named "Workbook2" which is not open. I want VBA code in userform1 of workbook1 so that when a commandbutton is clicked then it will copy data from "Data" sheet to a copy of Workbook2 and send copy of workbook as an attachment in email . I want all of it to be done using VBA.

Thanks​