automatic filling of multiple rows and columns and filters

good morning I need some little information. I have this file. this file consists of 3 sheets. on the first 4 columns there is a tree structure with the same items but arranged on different lines...