I need to move a sheet from one workbook to another workbook. I'd like to
create a button that uses a macro or
vb script to accomplish this. I can
create the move macro, but the catch is that the sheet that needs to move
will have a different name every month. So I was thinking of the code popping
up a form that I could type the sheet name in that needs to be moved and it
will then move it. I'm familar with forms, text boxes, and basic
VB, but need
some help with the code here. Thanks for any help you can provide.