looper to copy tabs of a data file into template and save as

[amartin575]

Hello,

I was wondering if someone could help me out. The attached file is a template. I have another file running overnight that will generate a data file with over 100 tabs of different companies. I need the looper to copy one of the data tabs into the attached templates "detail" tab and then do a save as. Close the file and then copy the second tab from the data file into the attached template and do a save as and so on. In the end I should end up with a template for all 100+ tabs of data. Any suggestions would be much appreciated.