Auto-populate front sheet or summary sheet with data from multiple tabs or sheets

Hello experts
I have a challenge that I would really welcome some help with.
I have been tasked with creating a spreadsheet that captures similar data for three different business areas in three separate tabs. Simple enough
Then, ideally I would like a front sheet, or summary sheet that takes some of this data (the high-level detail) from all of the tabs and automatically populates it into one consolidated view, displayed in date order.

The purpose: my boss is in charge of a team of three event managers, each with their own account. He'd like one view of everything that we are working on, rather than having to check across three different databases or spreadsheets. He only needs to see certain level of detail, whereas the managers need to see all of the detail associated with their events. We're trying to reduce duplication of work.
Think of it as a internal version (three data tabs) and an external version (summary sheet), that he can easily look-over and in turn, share with his boss.

I know I'm missing the obvious of simply hiding columns and using one simple list for all... but we need to keep the data separate.

I've attached an example for the month of September 2021, but am looking to create this for all the months of the year.

The second challenge is that I am working with a 2008 version of Excel! (my goodness me!), so perhaps this challenge is three-fold:
1. Is this even possible?
2. If so, is it possible in 2008 Excel
3. If not, what would I need to enable / upgrade to to get this working

I've had a quick go at appending... (on a different machine as I don't have the required add-on), but this seems to just stack my data tables on top of one another, rather than consolidate and display in date order...

I'm not precious on how it looks, the functionality is so much more important!

Wow. I realize I might be asking for the world! Any and all advice welcomed, or if there's another way to achieve our challenge I'd love to hear it. And thanks in advance.

Yes, it can be done (I was using XL2007 until fairly recently).

I'm just about to take a break now, though, so I'll pick it up later if no-one else has.

Pete

Oh my gosh Pete, thank you. No rush. I appreciate the response and super glad to hear its achievable!

cmann89

See if this is how you wanted.
If not, I need to see your desire result in "Front Sheet".

Please Login or Register  to view this content.

Hi Cubangt, no not quite. I would like just some of the data from the three tabs into the front sheet, and then to display in date order... and then automatically update should a new row of data be added to any of the tabs.
Hope that's clearer

Hi Jindon, thank you so much - looks like I need to contact my IT team to get around the security macros - as soon as I've done this I'll be able to check what you've very kindly created for me. Will get back to you ASAP.

Hi Jindon!
I think this is great! I need to adjust the date range but I think this will work! Thank you