I've encountered an issue and I've been unable to find any literature on how to solve it. I'm importing about 30 source files into a single workbook. Of these, roughly 20 of them come from other areas of my company. I have zero control over them altering the layout of these source files, so I'm running into an issue where the code is either failing OR I'm getting incorrect results as a result of the layout change. Example: My code copies the date in column DN of the source file and pastes it into the destination workbook. Now that date is in column DO, so I'm getting incorrect results. Is there an efficient way to review the header text to ensure it equals "Date" and if so, proceed with the code. If the header text doesn't equal "Date"; find the header text that does equal "Date", and allow the code to continue with the new column position without manual intervention?