Menu tree

Hello,


I would like to get assist writing a macro that explode a menu tree.

I have a menu tree file which contains menus, sub menus and menu's items (sheet "Source").
I would like to create a flat menu tree file. Each menu line will contain its own items and all the items related to its sub menus. (Sheet, "Requested Result ")
Please see the attached file

Thx
Eitan