Create summary Tab from data in other tabs

[macRBC]

I have three tabs. I want a 4th tab to show the data from those 3 so that if I modify a line in one of the tabs, it’ll be reflected in tab 4. Below is an example:

Tab 1 = colours
Red
Blue
Orange
Yellow
Tab 2 = flavours
Vanilla
Strawberry
Chocolate
Tab 3 = flowers
Daisy
Mum
Rose

Tab 4 =
Red (from tab 1)
Blue (from tab 1)
Orange (from tab 1)
Yellow (from tab 2)
Vanilla (from tab 2)
Strawberry (from tab 2)
Chocolate (from tab 2)
Daisy (from tab 3)
Mum (from tab 3)
Rose (from tab 3)

[fpy]

@macRBC

many

→ Paste Special - Link

[robleyd]

https://help.libreoffice.org/latest/en-US/text/scalc/guide/cellreferences.html?DbPAR=DRAW&System=WIN

[macRBC]

The tabs that will link to the summary page contain many lines hence I was hoping that I didn’t have to do one-by-one link to respective line in tab.
I guess I oversimplified my example.
Each tab has 6 columns and 10-200 lines. Those 6 columns and X number of lines I want carried over to the summary page.

[schiavinatto]

Ola @macRBC , utilizando macro ligadas ao evento de planilha / conteúdo alterado.

---

Hi @macRBC , using macro linked to spreadsheet event / changed content.

macRBC_125136.ods (10,9,KB)

---

macRBC_125136_v3.ods (15,1,KB)

[koyotak]

named columns in matrix{}-areas are summarized in TAB0
00000_LO-CALC_TESTESTEST-v0000_084129.ods (39.5 KB)
you can easily expand instead a named column to a named area