Formatting Legacy Data - VLOOKUP?

Hi I am importing Legacy data into an Excel Spreadsheet -

I have imported Date-of-Birth but this field is in different columns for different people - the field can be found anywhere from Column C to Column Y -

Imported example "BIRTH: 04/01/2000"

I want to find "BIRTH:" in a cell then copy the entire contents "BIRTH: 04/01/2000" to another cell -

I have used VLOOKUP but never for searching text and I cannot get my syntax correct -

As a side note - I have at least 10 different fields I need this code for but possibly 20 - I'm importing from a PDF and was able to configure as a CSV but the fields are everywhere b/c the records have different info -

This data will then be imported into another database for end-user searching so I need the fields in an already pre-determined order -

Greatly appreciate any help - Thanks!

Just one question - did you have to make this look so simple? ;

Thanks this is EXCELLENT! -

This will be invaluable as I have 4 or 5 separate files [1 file = 1 year] to convert for a company w/500+ employees - Thanks again