Batch Macro_output desired tab from input workbook to specific tab in output workbook

[nathanedwards]

I have a single workbook that has multiple tabs. 5 of those tabs are related to specific revenue sourcing (sold clocks, lease clocks, wire, deposits, ach). This needs to be my input. I want to build a batch macro that looks at the tabs from the input and then outputs them to output tools that are directed to specific tabs in a state workpaper workbook.

For example: sold clocks tab from the input will be viewed and it will copy and paste all transactions related to Arkansas to the output tool related to sold clocks in an AR State Workpaper. It will then do the same thing for lease clocks to the lease clocks tab in the AR State Workpaper.

[OTrieger]

@nathanedwards 
What you will need to do, is to ensure that the sheet name changes based on the date in your output path:

\file.xlsx|||[variable]

\file.xlsx|||Watch

\file.xlsx|||Sales

etc.