Copy Data from 1 Sheet to Another

Cross- Posted http://www.mrexcel.com/forum/showthread.php?t=481002

Hello Experts

I have PO ( Purchase Order) around 64K

All are in Same Column and Row, First PO Start From A1:J63, and after 2 Blank Rows i.e. A64:J65 , There is another PO (A66:J128 and So on,


In another Sheet I have Summary Report

Now, what I want to Display Yellow Colored Cell in Summary Sheet Like This

Means i have to Get Data from Column A,C,I ( A7,C15,I6,I7,I27)

And, Then i want A72,C80,I71,I72,I92)

That Mean After Every 66th Row i want the Data, the Format is Same But the Information is different




Is it Possible With Formula or I have to Copy Paste these information


Any Solution is Much Appreciate