How to combine multiple sheets and sort the results in Google Sheets?

Question

I have a "main" sheet like this (which is single words, not compound words):

---

---

And I have a compound word sheet like this:

---

---

Notice the slightly different columns. How do I combine both lists, aligning them at the custom column, and then sort the result (and ideally so it's non-editable)? I can slightly adjust the columns if necessary.

I would like to do it in the 3rd "full" sheet.

I tried this:

=SORT({main!A2:D;compound!A2:D},1,TRUE)

But it doesn't sort them by the custom column, and I'm not sure I have it right.

Answer 1

Can you post an example of how you want the columns to allign from both sheets? You'll be able to do it with Sort as you've said, but slightly different depending on how you want to organise the combined content