Please correct or expand

You said (with my Q's and Comments):

hello to one and all, and thank you for a little help. I'm a novice and have learned code on my own (ugh) but I've used Excel recording macros as a start, and read what I needed from articles across the net. I'll post the excel recording of what I'm doing, and the variables.

I'm copying [SheetName (Dog123?)] from a master file, putting it into a new file, and then creating additional copies of the same [Sheet] in the new file. This approximates our electronic batch making file process in the plant. I'm just trying to automate it.

Example: Batches 1 - 4 from [What??? A formula??? ]. Copy [Sheet] Dog123 in the master file, open new file, paste copy of Dog123 in the new file, give the tab the [Name] Dog123 (1), the copy Dog123 (1) three more times changing the header for the tab each time to Dog123 (2), Dog123(3)... Sorry about being long winded here, but its hard to describe.

Thanks for the input:

Using Formula from a spreadsheet and pulling it into the name of the sheet [What does this mean( pulling a formula into a Name)?]

Using count to add the extra labeling to the tab name and also count how many times to repeat the process before going to the next batch.

------------------------------------------------------------

I am moving this to the Excel Forum for better response. SamT