UDF's can't automaticaly add sheets, a Change event will be needed.
In the UDF, the variable eventDelimiter is set to vbCr. That line could be changed to vbCr & vbCr.

I'll take a look at your attachment after work. A change event testing if a new sheet is needed and creating it, including the formulas, is doable.