You could always just copy the sheet

Right click sheet tab > select move or copy > tick create a copy > then with the drop down select new workbook or the workbook you have set up from list and press ok

http://www.bettersolutions.com/excel...I749519511.htm

VBA Noob