Hi,
I've got a huge problem.
I surfed now thru various forums but I unfortunately did not find an
answer.

Here a description:
I have several sheets in one Excel workbook (with identical column
names and content). Now I would like to have a consolidated sheet with
all content of the other sheets WITHOUT using a VBA MACRO.

I am looking for a formula/ formulas which helps me to have a
consolidated always up-to-date sheet including all content rows from
all other sheets. The main problem I have is how to ensure that added
new lines in one of the worksheets are automatically added to the
consolidated sheet.

If you need an example Excel file I can provide you one.

Thanks in advance,
Best regards, jan