auto fill excel columns from different sheets with a specific order

i would like the column B and C in sheet 1 be filled same data from column B and C from Sheet 2. The number of the rows of these columns in sheet 2 is not stable and when it finishes i would like the rows be filled with data from column B and C from Sheet 3 and so on. in summary i would like in sheet1 to have 2 columns (B,C) filled with data from columns (B, C) of the sheet2 and when these data finish filled data from columns (B, C) of the sheet3 and so on. i would like when i open a new sheet and paste my data to the columns (B,C) these data copy in sheet 1 to the same columns (B,C) right under the data of the previous sheets eg sheet1 B c 6984748773 6935780981 6989080980 693578099 6998080880 693578100 6586707008 693578101 0897780778 693578102 7077807800 693578103 7087078070 693578104 sheet2 B c 6984748773 6935780981 6989080980 693578099 sheet3 B c 6998080880 693578100 6586707008 693578101 0897780778 693578102 7077807800 693578103 sheet4 B c 7087078070 693578104