How to source data from multiple Sheets

How to combine multiple sheets into one data merge using IMPORTRANGE or ARRAYFORMULA functions