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