Copying data from sheets named A to Z in one workbook and pasting as values in another workbook in to sheets named A to Z

[DannyL]

Hello, I'm trying to copy data from a locked workbook with 26 sheets named A through Z. I would like to copy data from all sheets in to another workbook as values in with the same worksheet structure

Thank you

 

[arthurbr]

This addin does the trick very nicely