Need script to copy from multiple sources and make multiple copies if needed

[devildogdad76]

Hello all,
Thanks to the help from Mumps1, this script is doing almost everything I need it to do. I have 2 remaining issues, listed below, that I don't understand enough to fix myself. When looking at the Summary page I have added a macro "Build Example" to show what I would like for the end result to be. The button "Build Report" has the current script attached to it that I need help with. Thank you in advance for any and all help with this.

1. I need it to copy the data entered on the summary page and paste it to the top of the report page before anything else. For the test it would be E9 - E20, but could be as large as E9 - E56 or as short as E9 - E12 when in production.

2. The code recognizes when the install type name changes, but currently it will only copy an item over once and then skip any repeats of the same item name. I need it to copy a template over for each time a specific item is listed in the Install Type column of the summary. Items will always be listed in groups and in the same order as the tabs along the bottom are listed.


Here is a link to the previous post as well. Not sure if this will provide any further clarity, but figure that it can't hurt.

https://www.excelforum.com/excel-pro...fic-cells.html