search for a name and then filter on it

I am a noob and ask forgivness... I have search high and low, but to no avail i have not been able to find what I am looking for..

I have a report that comes in a few different formats... the headers are not always in the same spot ( I have no control over that). One report the column may be in A10 and another may be in Z7... etc

I am looking to build a macro that will find the column named "OVLP_TYPE_**" (without quotes). Once that column is found i need to filter on that column for the term "CNC" (without quotes). I can then use the rest of the code i made to copy paste the results to another worksheet

any help would be great and if more info is needed please let me know

-g