Create multiple workbooks from sheet and name according to the list in another sheet

[milosh84]

Hello,

I have a main excel file in which there are 12 sheets named according to the months in a year and each of these sheets contain time recording template table. Apart from these 12 sheets, there is one more sheet where personal data of employees are: name, position, sector, etc. I need to create for each month (sheet) a new workbook that is named according to name (Range B2 and further) and sector (Range I2 and further) of employee. Directory to be saved is not the same as of the file, but the new folder.

Thanks in advance for a help