Generate sheet with lots of variation

Good afternoon everyone, thank you for taking the time to look at this
Here is my issue, I need to upload my stock to our Shopify site.
The problem is it has to be in a specific format for it to work correctly
I have many 100's of t shirts that have variations as in
small medium large etc
black, white, navy blue etc
And each product has its own specific SKU, i.e.
3957 SML WHT
3957 MED WHT
3957 LG WHT
3957 XL WHT
3957 2XL WHT
3957 3XL WHT
3957 4XL WHT
3957 5XL WHT
As you can see the common denominator here is the text after the number, so the number 3957 with have many variations and all are different
On sheet 1 I have my numbers which are unique, can i generate on sheet 2 the corrosponding codes
I have attached a workbook with what i am looking for
Not sure if I managed to add an attachment...
Thank you
Kim