Google Sheets Whizz

We are working with multiple customers on a training programme (it involves lots of coordination). We're looking for a whizz at Google Sheets to create an overview tab so we can easily & effectively the key actions for the other tabs. Here is an overview but happy to explain what we need over a hangout. Attached is a screenshot of an empty tab.

> Need tab to summarise every founders journey tracker in one table
> Need a separate table on tab where outstanding items are displayed
> Need tab to recognise when an item is outstanding from the separate founder tabs and show this in the summary
> Need tab to recognise any changes made to individual founder tabs (both on journey tracker and outstanding items) and then show these changes automatically on the summary (without it having to be manually amended).