Excel 2007 : Copying from multiple templates based on criteria.

Only change (other than setting your start row to 4) was the following line -- I used this in place of the call to "Template" you had in the attached sheet.

Worksheets(ThisWorkbook.Worksheets(strSrcName).Cells(rngCell.Row, 3).Value).Copy

As long as the C column contains the template name, this will work for you.

SOlution attached.