Create an Auto Fill, Cascading Table

Patrick2788 

Of course, sorry just felt I should avoid it if possible, should be fine though. 

Quick breakdown, one of my main component screens is on the left (014's), filtered to a given P/N, I am seeking to have cell A4 cascade out to show where all this P/N will go.

Center screen is a massive list of all Parts, and their sub-assemblies, many of which may break down several layers, such as a 125- end item in Col A having a sub component related in Col D. That sub itself may also appear further down in Col A, with another sub, or part number related to it. This is broken down a little visually with some filtered searches of this list on the right side, showing this 014 going into 4 different subs, taking just one of those and showing it going into three others, then one of those into four, and one of those into our 4 end levels.

I can somewhat split out the Bom list (middle) into a few different tables, but this becomes muddied quickly, as some parts will only have 1 level, such as 010's going right into the end levels, versus our 014 example with several different branching paths.

That all being said, from what I played with the pivot tables yesterday and in the past, I can imagine it working for a nice format visually to show this, but i'm unsure if it can loop back over columns A and D like I would need it to do, which leaves me to believe that a table filled with index formulas reference the findings of the previous column, still seems the better option. Unless the array formula makes that all easier...