Challenge: 3 different sheets, 1 summary sheet, how to link up?

Hi,
I have an Excel challenge and I don't know how to approach it, I would be grateful for any support!

I am working with three different events teams, and each team will "own" a separate sheet of the same Excel workbook. The header row of each sheet will be the same.
Their task is to list their respective event bookings on their one sheet of the workbook, in chronological order.
The data will be added from time to time on each sheet, and lines may need to be inserted on each sheet.


I will then need to create an "overview" or "summary" sheet, which draws in all the rows of each of the sheets, i.e., from the three different teams, in chronological order (of the event), to create a single overview of all events taking place.

Which is the best way of doing this?

Many thanks in advance.

And would you then like to display the composite list of events in a calendar-style display?

It would help if you attached a sample Excel workbook so we can see exactly how your data is laid out.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button), as it does not work on this Forum.

Hope this helps.

Pete

I won't be able to upload the sheet due to data protection, but there are 15 columns, and up to 100 rows per sheet.
Does that help?

Mock up some sheets with expected results. Ensure ranges (columns/rows) are as required in your "real" worksheets.

Use PowerQuery aka Get&Transform (Data tab - Get&Transform section) - Append all three tables into one, sort by event date (or whatever you want) - load into the summary sheet (or create Pivot Table from the result of PowerQuery table: Append1)