I'm using Microsoft Excel for Mac 2011.

I need to copy a protected sheet which is a "master" and then paste it to the same workbook as the original

I want to have a dialogue box to add the name of the copied sheet before the copy is made. The copy will then be used and kept as a record. Then another copy made etc

I have no programming experience but am otherwise pretty good with all excel operations.

The resultant workbook needs to work on Windows PCs and MACs

many thanks in advance