|re: "I want to create a batch file that can copy this worksheet from each of the excel files and save each one of them in a separate file."|
As opposed to copying the sheet, I think it would be easier to delete all the other sheets and then save the remaining sheet as it's own file. The original file wouldn't be impacted because it wouldn't get saved.
Is it always the same sheet in each workbook? Perhaps the same name or same location (Sheet1, Sheet2, etc.)?
Somehow we'd have to tell the code which sheet in each file we're interested.
You'll need to provide some more detail before we can offer any assistance.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.