I have searched and searched about this topic, but haven't come up with anything that is exactly what I need.
I am looking for a command button that will pull specific sheets out of a workbook and put them into a templated workbook that has a cover sheet generated, then re save that as a different name.
Within this workbook i am pulling sheets from, there is originally only one sheet labeled TR. I have a button that copies and creates new sheets from this sheet, which then goes up numerically TR(2), TR(3), and so on. The code I was looking for is for it to grab all the TR sheets and copy them into a templated workbook without the macros or formulas, just the values. Or at the very least just into a new workbook.
Any help would be greatly appreciated, thank you!!!