Best way to create a rollup of multiple sheets in the same Excel workbook?

Question

thanks for any help. I have a workbook with 8 sheets with identical columns. These sheets receive multiple new rows every day. I would like to make a 9th sheet that combines all these entries into a single table with those same columns.

I am not sure of the best way to do this. In searching, I have seen a lot about consolidation, but that is adding things together and getting SUMs etc, which I do not want. I simply want this data basically stacked on top of each other in one big table, rather than separated into 8 identical tables as it currently is.

Is there a best way to do this besides me manually moving everything to the rollup tab? I'd like it to automatically grab new entries, since new entries will be added probably every hour of the day.

Thank you!