Macro – If Equal to Variable, Copy and move to Next

MarvinP, I really appreciate the help. I have one more question about a macro to complete the spreadsheet. I know that I should be able to figure out how to make a similar code as the previous one that you sent me, but I seem to be having trouble. Similar to the other code, in the same workbook there is a “Summary Tab” that summarizes the amount of hours allocated for each employee, I need the code to extract the name of the employee that has hours in the respective CTR sheets to the sheet titled “CTR-01” in the section titled “Personnel”. The “CTR-01” sheet currently has a drop down list, again I’m trying to eliminate a step in which the user would have to manually chose the name of the “Personnel.” The original spreadsheet has 20 CTR sheets, but I assume that once the code is written it should be easy to include in all the CTR sheets. I have attached another spreadsheet to help my inquiry make more sense.