Template with Macro won't work once copy of template is made and file name is changed

I created a Simple Macro to go to another excel file and copy information from that excel file back into a template. However since it is a template the file name will change when a copy is made to be used and because I created my macro by recording it, it won't work in the new file because of the new file name. How do I make this macro dynamic with the changing file name? It errors at the - Windows("Trial Updated_Sharon_DO NOT USE.xlsm").Activate- line because the file name has changed.

Here is my Macro (I am very new at writing macro's so please forgive my crude programing below):

Sheets("Master_Part_List").Select
Range("A1").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.ClearContents
Range("A1").Select
Workbooks.Open Filename:="Z:\Jobs\HARTJE MAST.xlsx"
Range("D1").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Copy
Windows("Trial Updated_Sharon_DO NOT USE.xlsm").Activate
ActiveSheet.Paste
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Bid Material").Select

Thanks for what ever assitance that can be provided

Hi Holger

Thanks for this. I am having two errors with it (Again so new at this that it might just be something easy I am missing):

1) I am getting a run-time error at - sheets ("Bid Material").Select line. Not sure why.
2) Also it is getting to this point however the information that was copied from the Hartje Mast file is not pasting. It is suppose to paste into a tab titiled "Mater_Parts_List". Since I used the Macro record button I doesn't look like this was included in my first post.
3) The Sheets("Bid Material").Select is the last thing that should occur setting the screen view for the user back to that tab.

Again Thanks for taking the time to help
Sharon