Finding and Replacing Data in a Header Row
 

I download an excel file from an outside source (which I have no control over the what columns, rows that are or, are not included)... raw data. There can be 60-120 columns of data. Row 1 Contains the Headers.
The raw data is on Sheet 3, row 1...

EXAMPLE: Column AM, the project name is; "D26B Faucets (Rollout) [000000419]",
There can be anywhere from 10-30 projects listed in Row 1
I have a Project List on Sheet 4 Column N which will contain "D26B Faucets" and as many as 10-30 projects

WHAT I NEED: is the most efficient and effective way to replace the Project Names on Sheet3 with those names on Sheet4.

Any ideas would be appreciated!