Macro creating new sheets from the list

Dear friends,

currently I am facing one issue which is fully out of my knowledge so let me kindly ask you for your help.

Let me explain what I need to do with enclosed spreadsheet.

In the sheet "Analysis" is column "C" called "Account Group". Currently there are 33 rows, but only 2 account groups (DE-XX-XXXX-25002X-PXXXX & DE-XX-XXXX-25002X-PXXXX(1)). Of course, there can be more or less items, this is only example.

Sheet "LL - Account3.1 BH" represents blank layout template.

I need to write macro, which makes following steps and result:

For each group from "Account Group" column macro will create 2 separate sheets by copying "LL - Account3.1 BH" template and named it as follows:
0L + Account Group Name (e.q.: 0L DE-XX-XXXX-25002X-PXXXX)
Y1 + Account Group Name (e.q.: Y1 DE-XX-XXXX-25002X-PXXXX)

and to every new created sheet will be copied Account Group Name (same as is named sheet, e.q. 0L DE-XX-XXXX-25002X-PXXXX into cell: "H7".

Thanks a lot for any advise from your side