Copy Worksheet Wiki
Open source Excel add-in to automate conditional worksheet copying
Brought to you by:
solutionfree
Adding an add-in is straight forward. You first need to make sure the 'Developer' tab is visible, see many post on doing this including https://msdn.microsoft.com/en-AU/library/bb608625.aspx.
Next select the 'Copy Worksheet V7' add-in from the location you have saved it when downloading from https://sourceforge.net/projects/copy-worksheet/files/Copy%20Worksheet/Copy%20WorkSheet%20V7.xlam/download.
The best place to save the download is the Microsoft default location, normally C:\Users{user name}\AppData\Roaming\Microsoft\AddIns\ , but could be different.
Add the add-in as per the prompts (see below), then the 'Worksheet Copy' menu will be available for all subsequent workbooks on the PC.