I have a workbook and on the first sheet is a button that I would like to attach to a macro. I would like the macro to create a new worksheet and copy data from another sheet inside the same book. This "template" sheet is hidden so nobody messes with it. I just need the contents of that sheet to copy to that new sheet that gets created from clicking the button (macro). I know I have worked workbooks that have done this and much more. I would love to know how to create a form that would populate the new sheet rather than copying data from an exisiting sheet - but this will work and should be easier and quicker to implement.

Thanks

Matt