VB Code for outlining a Status based on Criteria within grouped Rows

Hello,

I am continuously starting to use excel at the workplace, and finding out more and more I don't really know too much about the program. I am an Excel 2007 and VB code newbie, please bare with me, I will do my best to explain my current problem

I have a Macro-enabled excel workbook that is used to review content, there are two different grouped content reviews which are housed within a hidden 'Templates' sheet. On another worksheet is the actual Review page, on this review page there is a macro-enabled button which basically takes one grouped review from the 'Templates' sheet and pastes it in to the work book (this can be done multiple times, and new grouped reviews are always pasted one row below the last). Within each grouped review, there are about 32 different Criteria which can all have a 'Pass, Fail, or N/A' status. What I hope to do, is add a 'Current Status' row beneath each grouped review that looks at the Status off all Criteria and assigns a 'Pass or Fail' state depending on whats outlined in the criteria. So if i had all Passes, it would show up as 'Pass' in the Current Status, but if i had one 'Fail' it would show up as Fail.

Since I have a macro button that simply copies and adds a new review one row down, I am pretty sure I'll have to include some more VB code in the module so I can have my vision brought to life.

I have included the VB code for adding the new grouped review, as I suspect there may need to be more code added to this so it can properly display the status.

Any information and help you can provide is greatly appreciated!!!!

Thank you,
- Eric