Combining multiple spreadsheets into one with importrange and filtering out empty rows
Use importrange to combine the spreadsheets, then a filter function to make sure the consolidated data refreshes as the source data does and remove blank spaces
AUTOMATICALLY COMBINE AND UPDATE DATA FROM TWO OR MORE SPREADSHEETS
Combine data from multiple spreadsheets into one that updates dynamically in real time