Copying from multiple sheets (same column) to a main sheet (column)

Hi folks,

I had a question. Anybody knows a way to quickly copy the following data from sheet 1 and 2 so that in a separate sheet "My sheet" I get the info from column A of sheet 1 and column B of sheet 2

Columns (same columns in all sheets)

sheet 1

Column A Column B

234 912
456 231
345 112
267 225

sheet 2

Column A Column B

332 874
342 546
210 673
213 723


My sheet

Column A Column B

234 912
456 231
345 112
267 225
332 874
342 546
210 673
213 723

Thank you in advance

Hi, the point is that I have 20 sheets with over 15 columns each (each column has about 1500 observations). So, what I want is to have the observations of the same column of all 20 sheets copied into a specific sheet (column). For example, all observations of all column A-s from all 20 sheets, into one column of a specific sheet.

I've heard about OFFSET function, I just don't know whether/how it could be applied in this case.

Thanks again.