Copy Data1 and Data2 to Main Sheet

[Narend]

Hello Genius,
I have a query and query is I have a file which has 3 nos. of sheets,
i.e. Data1 and Data2 and Main Sheet.

I have some data in Data1 and Data2 and I need to copy the data from both the sheet into sheet 3 i.e. Main sheet by Excel formula only not by VBA and it should be dynamic.

I have attached the file (Copy_Data1_and_Data2_To_Main.xlsx).
Kindly help me.
Regards
Narendra

 

[xlstime]

Please see attached.

Hello Genius,
I have a query and query is I have a file which has 3 nos. of sheets,
i.e. Data1 and Data2 and Main Sheet.

I have some data in Data1 and Data2 and I need to copy the data from both the sheet into sheet 3 i.e. Main sheet by Excel formula only not by VBA and it should be dynamic.

I have attached the file (Copy_Data1_and_Data2_To_Main.xlsx).
Kindly help me.
Regards
Narendra

 

[Narend]

Please see attached.

Thanks xlstime you are truly untitled legend.
it helps me a lot

 

[Narend]

Please see attached.

Respected Member,
when I delete some data from data1, the data from some cells have been disappeared. Pls see the attachement.
(When I delete data from data1 some data from main sheet disappear, kindly suggest.

Regards
Narendra

 

[xlstime]

Little correction

cell a2 =IFERROR(INDEX(INDIRECT("Data"&IF(ROW(A1)+1<=$E$1,1,2)&"!A2:A"&IF(ROW(A1)+1<=$E$1,$E$1,$F$1)),IF(ROW(A1)+1<=$E$1,ROW(A1),ROW(A1)+1-$E$1)),"")

cell b2
=IFERROR(INDEX(INDIRECT("Data"&IF(ROW(B1)+1<=$E$1,1,2)&"!B2:B"&IF(ROW(B1)+1<=$E$1,$E$1,$F$1)),IF(ROW(B1)+1<=$E$1,ROW(B1),ROW(B1)+1-$E$1)),"")


paste and drag

Respected Member,
when I delete some data from data1, the data from some cells have been disappeared. Pls see the attachement.
(When I delete data from data1 some data from main sheet disappear, kindly suggest.

Regards
Narendra