rearrange multiple small tables with non matching column titles - into one large table

Hi
This is my first time on here - I thought i was relatively competent with vlookups pivot tables etc - but does anyone know how to rearrange multiple smaller tables (i think I can try and get rid of blank rows etc) into one large one if the columns are not ordered in the same way - i was thinking of a vlookup and then maybe an IF statement to try and match up the category title? Any help greatly appreciated!! i have put the two before and after examples below:

This is the original data:
Name number Category titles

b2 c3 e5 f6
natalie 123456 20 30 50 60

a1 b2 d4 e5
james 456789 15 25 45 55

Trying to transform above data into this:
a1 b2 c3 d4 e5 f6
123456 20 30 50 60
456789 15 25 45 55

sorry in the above example the column titles have all moved - i have tried to attach the excel file

WOW - you are amazing! thank you so much!

i do not know how to tag this as solved sorry

Hi apologies but does anyone have a formula that does not use offset as the problem is that the number of columns and order of the columns may change?
I think maybe a lookup formula to match the number with the category title and return the score when the numbers and categories match?