Changing Worksheet Tab Name Affects Macro

[nhbartos]

Hello...
Novice and new here...
I know how to very basically record a macro, but not where or how to insert fixes or work arounds.

Macro 1 creates a new data sheet by copying a template tab named "New Data Sheet" for each client as they come aboard, titled "New Data Sheet (2)".
Macro 2 runs after Macro 1 and it is supposed to link the data cells from the "New Data Sheet (2)" to a "Summary Sheet".

With me?

The problem is:

If I run the macro with the tab titled "New Data Sheet (2)", it works fine until I change the tab name to my clients name "Jones, Tom".
Even if I change the tab name to "Jones, Tom" first, the macro does not run at all.

So, it only works once.

I need a way to make the macro work regardless of tab name changes.

Is there a way for VB to maintain the linkage another way so I can change the tab names?

If so, I would appreciate the help and I would also need help knowing exactly how to insert the fix as I don't know the lingo well yet.

Thanks!

 

[RoryA]

Pleas post the code for the first macro - you can have that rename the sheet to anything you like. It also sounds as though macro 2 should really be connected to, or called by, macro 1 - is there a reason it isn't?

 

[nhbartos]

I fixed it...thanks for the reply.