VBA that copies module and code into a new workbook

It's a bit hard to comment without more context, however a workbook template might be more appropriate, possibly and addin, or put the code in the sheet so that when the sheet is copied, it takes the VBA with it