Check this link BalaReva.Excel.Activities - #14 by balupad14 shows a custom activity for copy sheet install this custom activity works perfectly for me
Edit :
Which version of excel activies you are on ? In 2.5.2 I am able to see copy sheet , if on a lower version check if you are able to update it .
Else check if you are able to install below activity and use it