The code below is working fine and creates a new sheet.
The newly created sheet is saved by a constant name.
Can be saved with the name of the sheet whEre the new sheet created plus a number (or no number just the name).
(i,e. the name of the sheet that will get data and create a new sheet named 1.Power Distribution - Dimmer, so the new workgroup saved as this name)
I have uploaded example. The module need to be changed is Module5