I am guessing that at the time of the running  of your macro's, you would
know the name of the workbook.

So, you could setup a variable that you would fill-in at the time you
run the macro.

Dim strWorkbookName as String
strWorkbookName = InputBox("Type the Name of your Workbook") &".xls"

Then anywhere in your macro  where you are specifically referencing a
workbook, replace that information  with strWorkbookName. So
("Master.xls") would be replaced with (strWorkbookName)