runtime error 1004 - using a single macro for multiple reports

Hi All, I searched this error and could not find any relative solutions for this specific problem. Let me preface by mentioning that I'm very new to Macros and VBA, so this could be the easiest fix ever..

I am trying to record a macro that I am able to use across different reports that I pull daily. Each report has a different name and data. When I record a macro in file "MD 12-7", I have no problems. When I run this macro on file "MD 12-9", I get the runtime error 1004. Looking at the debug, it seems as though I need to have a dynamic file name, as the code pulls for "MD 12-7!R1C1:R100000C14" each time

Here's the entire macro:

Please Login or Register  to view this content.

Here's the error:

Please Login or Register  to view this content.

Hah! That's the tiny piece I was looking for, thanks for the quick reply!

For future reference, in terms of syntax, can I make the following edits on other macros with the same success?

i.e.

Please Login or Register  to view this content.

becomes

Please Login or Register  to view this content.