Problematic Auto-sort

Thanks for the help. I'm trying to auto-sort based on a data table.

In the attached sheet I've got a row of names (G1:AE1) and they have various types (AA, BB, CC, DD) and I'd like them sorted by the values in row 29, and for that to appear in (AA)A2:A12, (BB)B2:B12. The type is static, so if you help with the formula I can fix it for type (if I understand it).

I'd also like it to auto sort, so I don't have to sort each time the data repopulates.

Is this possible?

Thanks,

uttuck