Update to Script or New way to merge multiple google sheets

Job ID: 31999750

Budget: £10 – £20 GBP

I need to message multiple google sheets in the same workbook regularly, ideally would want to sheets to merge live but understand this is not possible.

The current script that I have merging the sheets keeps timing out as I now believe there are too many sheets and too much data.

Currently using google script to perform this merge every hour. I can send the script that is currently being run along with the data that it is merging. This hopefully will be a quick fix