Help: take values from many columns into one list, separate list to new worksheets

am very new to VBA and slowly working my way through the resources for beginners. While I learn, I need help with this time-consuming task:

I am analyzing an excel survey-output that puts the names of respondents and their partner id into different columns, depending on an initial language choice. I need to aggregate these names and partners into a single list. I tried writing a formula to no avail. In the picture below, I would need to move all the 1,2,3 into the appropriate NAME or PARTNER column.


Partner Reports_ Macro Help.xlsx


Ideally, I would then like to move the names into a single list on a separate worksheet, sorted according to the various partners.

Please let me know if you can help!