You'll still be able to use sheets from within an add-in just like a normal workbook. Just don't try and activate the sheets or anything as the code will fail. For instance, don't use code like this:-
Instead, use something like:-
There is no need to unhide sheets in order to copy them.