Writing a macro on the VBA

The services of a macros writing specialist are required. I need to write a macro on the VBA. Summarization by condition in the nested structure with 6 sublevels, the values that are included in the 6 sublevel, then 5 and so on to the final amount are summed. A formula is inserted into the cell, not a value. Details in the file