I am still not sure I understand, but I'll try anyway.
if you are working in the specific workbook  when the macro  (from your
Master.xls) is going to run  then, in your macro, why don't you try to pick up
the workbook name: Let's say something like:

dim strActiveWorkbookName as string
strActiveWorkbookName = activeworkbook.name

Does that help?