I have a spreadsheet with 4 tabs. Sheet 4 will serve as a ‘main’ sheet with the combined data from sheets 1 tot 3. The following formule is working van for the imported data.

=SORT(
    ARRAYFORMULA({
         IMPORTRANGE("sheet1URL","Sheet1!A2:E");
         IMPORTRANGE("sheet2URL","Sheet2!A2:E");
         IMPORTRANGE("sheet3URL","Sheet3!A2:E")
,1,FALSE}))

The formula sort on column A, which is a date. However, in the ‘main’ sheet, people can fill in column F and G manually. Those columns are not included in the sort function because they are not imported, but manualy filled in.

How can I include this so the entire row gets sorted?