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!