I've been working and looking for a solution/code for a while but couldn't find anything that would fully work.
1. 'Name details.xltx' is the template to be used for the new workbooks
2. 'Input REF.xlsx' is the master file with specific details for each Name
3. There should be as many new workbooks as Name in 'Input REF' (12 in the example)
4. Each spreadsheet (3) of each new workbook shall be pre-populated with data included in 'Input REF'