I have a workbook with a bunch of sheets, mostly lookup tables and a summary page. On the summary page I have a bunch of entries, 25 to be exact, that list out multiple groups.

For each group I need to run an analysis. I have made a 'template' worksheet that works correctly for Group 1. All i have to do for group 2 is copy the group 1 sheet, rename it to group 2, and all the data within the sheet uses the group name to look up info on the summary page and do the analysis. On the sheet if there's an error, cell B3 reports an error.

I need to have an analysis sheet for each group. I'd like to do it automatically. Here's what I've got, in the comments you can see some of the stuff i've already tried.

Please Login or Register  to view this content.
The first part works fine, if the sheet exists I get the value I wanted. But nothing works to do the actual copy. I've tried methods from multiple examples online, but I just can't get it to copy the template page (for now just the sheet called "Group 1"). If I could just get a new copy of that page to show up I'd be happy.

Any help is much appreciated. Thanks in advance!