Live copy of Table in other sheet

Hello guys,

I'm having the following problem:

I have a table (1-column "Prozesse" starting on L2) that works as support for other functions in my excel. It's located on a "support-sheet" (Hifstabelle 2)

prob1.png

I would like to have a live copy of it under the sheet "Auditierte Prozesse" starting on A5, so whenever I add a new topic to the Prozesse list in the Hilfstabelle 2 sheet, it will appear in the end of column of the Auditierte Prozesse sheet as well.

prob2.png

I've tried simply using = and then selecting the table under Hilfstabelle 2 but then I would have to extend the formula until infinity since I don't know yet how many topics will be added to the first table. Besides, by using this trick, the fields which are not yet filled are filled with "0".

Any ideas on how to do it?

Thanks a lot!
Lucas
EDIT: third photo with the sheets' names
prob3.png

There are few options.

1. Use PowerQuery. Do note that you need to refresh table to update data (you could set timer on it in query properties or write small code to refresh).

2. You could nest the formula in IF funciton. Ex: =IF(CellReference="","",CellReference). Note all formula method will require range to be pre-populated with formula. But update will be more immediate.

3. Use PivotTable with row label only. Unless you add source table to data model, you will need to manually refresh or use code.