Need help google app scripts for some spreadsheets

I have tried writing a google script to automate one of my spreadsheet tasks but it’s been taking me quite long. I have a couple of master workbooks I need to combine/merge data across all tabs, transform and load on a separate workbook. Can you help?