Trying to add variables into Worksheet statements and can't get the right syntax

[Freshpetguy]

okay. Let me give this a try again. I'd love to use the names of the files to help, but can't for proprietary reasons. With that said let me try again.
Part 1
The master file is located on our server. For this instance it is called "Formula Master".
It has on it a tab with one of our formulas with a given name of the formula called Dog123.
Dog123 is the first sheet in the file.
Part 2
To create a daily file
I give the new file a name (generally the date) for example "04.08.14"
I have the new file open
Go to the Master file, click on the Dog123 tab and create a copy
Paste the copy into "04.08.14"
Now my first tab is Dog123....
I then copy the Dog123 tab in file 04.08.14 and when excel creates the second file it gives it the label "Dog123 (2)
this process is repeated for the number of batches, in this instance let's say its two,
I then go back to the master to get a new recipe to copy in as batch 3 and what I'm trying to do is to be able to label the tab sheet
with the correct number of the batch to run for the day.