Auto-create tabs from list and template

teacup001 1 Posts Wednesday October 11, 2017Registration date October 11, 2017 Last seen - Oct 11, 2017 at 07:57 PM

I have a workbook with two tabs:

1. Tab name 'Index' If information is input into C4, then I need a tab created
2. Tab name 'Template' is the book to copy, but it is a template and needs information from the previous tab 'Index' :
B2 uses =+Index!A4
H1 uses =+Index!C4
H2 uses =+Index!D4
H3 uses =+Index!B4

So instead of manually linking to the Index page and inserting copies of the template tab, is there a way for it to automatically create a workbook full of tabs?

Please let me know if clarification is needed. Thanks!
See more