Need help to link Cell to a seperate sheet

[spycein]

Hello Everyone,
Need help to link data from one sheet to a different sheet.
For example, i have following data in Sheet 1 and Sheet 2:
Sheet1

Cell B1 Value = A

Cell B2 Value = B

Cell B3 Value = C

Cell B4 Value = D

Cell B5 Value = E

Cell B6 Value = F

Cell B7 Value = G

Cell B8 Value = H

Cell B9 Value = I

Cell B10 Value = J

Sheet 2

Cell B1 Value = 1

Cell B2 Value = 2

Cell B3 Value = 3

Cell B4 Value = 4

Cell B5 Value = 5

Cell B6 Value = 6

Cell B7 Value = 7

Cell B8 Value = 8

Cell B9 Value = 9

Cell B10 Value = 10

I need to copy the above data from both the sheets to a new sheet i.e. in Sheet 3 in following manner

Sheet 3 ( Need help to link data as following manner)

Cell B1 Value = A

Cell B2 Value = 1

Cell B3 Value = B

Cell B4 Value = 2

Cell B5 Value = C

Cell B6 Value = 3

Cell B7 Value = D

Cell B8 Value = 4

Cell B9 Value = E

Cell B10 Value = 5

Cell B11 Value = F

Cell B12 Value = 6

Cell B13 Value = G

Cell B14 Value = 7

Cell B15 Value = H

Cell B16 Value = 8

Cell B17 Value = I

Cell B18 Value = 9

Cell B19 Value = J

Cell B20 Value = 10

Hope i explained my query properly.
Many thanks in advance.
Best Regards

 

[Habtest]

Book1
	B
1	A
2	2
3	B
4	3
5	C
6	4
7	D
8	5
9	E
10	0
Sheet3

Cell Formulas
Range	Formula
B1:B10	B1	=INDIRECT("Sheet"&MOD(ROW()+1,2)+1&"!B"&(INT(ROW()/2)+1),1)

 

[spycein]

@Habtest Thank you so much.
I have a small query.. row number 2 value starts with 2 instead of 1. could you please help on that.
Best Regards,

 

[spycein]

Thank you so much.

 

[Habtest]

@Habtest Thank you so much.
I have a small query.. row number 2 value starts with 2 instead of 1. could you please help on that.
Best Regards,

Sorry for a mistake, should be:

=INDIRECT("Sheet"&MOD(ROW()+1,2)+1&"!B"&INT((ROW()+1)/2),1)

 

[spycein]

@Habtest Thank you so much.
Best Regards,