Hi guys, i am new to this forum and am have a hard time creating a macro from scratch so thought maybe someone could help.
I have 7 different excel files which im trying to create a macro that will combine all of this files (reports) into one, and then put the CT information (an excel file i have) on a seprate tab within the 1 common report.

any comments or suggestions will be much appreciated .

thank you .