I have a sheet with 4 workbooks in it. Sheet 1, sheet 2 sheet 3 and sheet 4. What I am needing is to set a patter in workbook 4 that is goes down the rows (sheet 4) as 

Row 1: =Sheet1.A2

Row 2= Sheet 2.A2

Row3= Sheet 3.A2

Row 4= Sheet1.A3

Row5=Sheet2.A3

Row6= Sheet3:A3

and the pattern on and on. When I keep dragging I will get a few in a row then skip then a few in a row correctly. Is there a way to get this pattern to allow me to just keep dragging down as needed?