Pulling data from jumbled columns

Hello, new here.

What I am trying to do is confusing me. I have a database exporting a lot of information. What I am specifically trying to pull from the data is a 5 digit code. this may be 5 numbers, or 5 letters, or (more often) a combination of the two.

The export has a ton of records (about 5,000 and growing) so manual withdrawal is not an option.

So, in column A is the part number, which isn't necessarily important.
Column B says "TEXT A, TEXT B, TEXT C, CODE, TEXT D, TEXT E"
Column C says "AAA, BBB, CCC, 12345, DDD, EEE"

So, at first glance I thought I would use Text To Columns, and just pull all the codes from that column. However, it gets worse

the column moves around in the database. Sometimes it's 4th, sometimes 11th, and sometimes it's first and there are no other columns;

so it might be
Column B says "CODE"
Column C says "12345"

or
Column B says "CODE, TEXT A, TEXT B, TEXT C, TEXT D, TEXT E"
Column C says "12345, AAA, BBB, CCC, DDD, EEE"

Does anyone have any ideas on how to pull this data out? I thought if I search for CODE and find what column it is, then pull a corresponding column, it might work, but that didn't work