Automatically create tables if other cells contain data

I'd like to create a table that can be linked to Word, regardless of the range size. To create this table I want it to include only the relevant data. It should point to cells and determine whether there is information in those cells, if not, whether there in information in the next cell. It will repeat this process until it reaches the bottom of a specific range.

If it is successful at filling a row with data, it will move on to the next row and continue from where it left off on the reference table.

So for example:

The reference table Includes

Title
Inventory
Equipment $50
Supplies
Other $20

The table that would be automatically created would include:

Title
Equipment $50
Other $20


This was just an example, the real creation may include tables that are over 30 rows tall. Thanks in advance.

Attached is a workbook that contains a table "input" table and the desired "output" table.

The output table should be automatically created based on whats in the input table. If you were to add more position to the input tables, the output table would get longer. The result should be something that I can define as a name so that when linked to word it gets resized when the link is updated. Thanks in advance for the wonderful help.

Any potential solutions for this? Thanks in advance.