Multiple names from data tables into one

Hi,

Im looking for a formula that will combine names from multiple tables into one combined table.
For example I have three sets of tables. (the order of names never changes) But I want the combined data section to bring it all together.
At the moment i have the name fields being pulled from my last table, but if that name isn't present in the last table but it is in the first I still want it to pull the name across in the same order. I have worked all the other formulas out as it is just adding and averaging certain data its just the name column I need to populate in the combined data section.

I have attached an example table so hopefully it all makes sense.

Any questions or would like me to clarify please let me know

Thanks for your help!

How should you combined data look like?

I have the data all combined in the top table within the attached example. I just need help with getting the names to filter into the table. The names will always be in the same order when they are put into the bottom two data tables further down the sheet.

Each data entrie is a different week.
I’m having issues having the sheet do this.
Example would be.

Paul has data for week 1 but not week 2 so the sheet would get his name from week 1 and put it in the table at the top in the same row of the table as it was fetched from the data table. Second example Sabrina has no data entrie for week 1 but she does for week 2 so this is where her name is pulled from and again filtered into the table in the same row as where her name was shown.
Example 3. Susan has data entrie for both weeks so the formula would pull her name from either data entry and put into the combined. Again like the other in the same row as the data entry tables.

I hope that all makes sense!