Export data from xlsx based on code name and save it to new xlsx with changed column name

Dear All,

I would like to export data from excel file to separate files based on the code name (codes are in one of the column). There are around 60 codes.
I would like that extracted data is saved to separate files with code names.
Also, I would like to modify columns in the new file from SUFFIXn to <code + SUFFIXn>, eg. ASUFFIX1

Exemplary input and outpu data is attached.

Help would be appreciated,

Regards,
D.

input.pngoutout.png