return data from multiple sheets

[HSOLDO]

hello

I have 20 sheets named 1,2,3....20 and one sheet named "report"

In every sheet I have 20 rows of data.
I need to put all data from each of 20 sheets to report sheet

It means A1 to A20 from sheet 1 will go to A1 to A20 on report sheet.
A1 to A20 from sheet 2 will go to A21 to A40 on report sheet and so on.

It means B1 to B20 from sheet 1 will go to B1 to B20 on report sheet.
B1 to B20 from sheet 2 will go to B21 to B40 on report sheet and so on.

Which formula on report sheet A1 I need so when I drag the cell down I get on report sheet the data from A1 to A20 from al sheets?

Thank you

 

[sandy666]

use PowerQuery (Get&Transform) with Append feature