Auto populate from 6 different sheets - Excel 365 and Google Sheets

[N0t Y0urs]

Hi, me again as you guys are really helpful.

My next question that I can't seem to figure out is there a way to auto populate a sheet every time you add a new entry to a different sheet.

This is the scenario:
5 sheets that I enter information into based on their filters. These sheets will have a minimum of 5 rows of data with currently the largest one being 103 rows.

I don't care about the order in which they report but can I have the summary sheet auto populate from the other 5 sheets? Or do I use the summary sheet as a "dashboard" to manipulate the data into more manageable insights?

Typing it out like this I think that is my solution however I would like to hear other opinions and if indeed it is possible to pull form 5 different areas into one automatically

 

[N0t Y0urs]

I have not found a way to do this at all so MY SOLUTION is to actually not auto populate but rather use a dashboard scenario to report the data in the summary sheet