OK, well here is the code.
We do not provide turn key solutions. Tweek this simple code to do the real details of what you are asking. Use the below cut and paste as a wireframe, and modify it to fit your needs!
' copytoanewfile Macro
' Macro recorded 9/29/2015 by onebaddass mf'r
Workbooks.Open Filename:= _
All I did was record a macro, now just tweek it to fit your needs!