Combining poorly formatted sheets

Hello everyone!

I have tried to convince my colleagues to use a version of the following with a date column rather than date headers but they found this confusing...

Now I am tasked with combining the two rosters that are created each month.

As the spreadsheet will be shared through Office365, my hope is to automate a combined roster so it is as up to date as the others.

I'm thinking I could potentially use named ranges or some kind of lookup to do this, but before I spend many hours experimenting I figure I should reach out and see if anyone has a suggestion for me.

I think I'll probably have to manually sort it out but fingers crossed there's another solution!