How to insert a table fragment by control value?

Question

excel

Task: There is a field and, depending on the value in it, one of the existing tables is inserted after it.
Approximately as in the pictures
Example
It seems like a simple task, but I have already killed a lot of time. Thanks in advance for your help =)

Answer 1

Elementary, but with nuances:
In column H you write "Elephant", "Dog", "kangaroo" opposite each element
In column A you indicate all parts of the body (both trunk and bag)
In column B you use sumifs()
more complicated:
In column H you write "Elephant", "Dog", "kangaroo" opposite the first element
In cells starting from A3, insert the formula:
=INDEX(J:J;MATCH($C$1;$I:$I;0)+ROW()-3; 1)
If something is not clear or does not work quite like that - let's discuss