I have an excel workbook that has seven worksheets tabs and on the last tab it has a a merge data button that enters the total for all the worksheet onto a word template. I works just fine. I need to add the report number to the word template that corresponds to the appropriate incident that is checked. I've attached the workbook and a word document of what the template should look like when merged.