I have about 90 different excel files, each of which is a report for a different customer. I also have a generic summary tab that I need to add into every one of those 90 reports. Is there a way to automate this process?

Basically, I have 91 files - 90 of which are unique reports and 1 file, which is the generic summary tab. Need a quick way to slot in that generic summary file as a sheet in all the reports.

Thanks in advance!