Copying specific data from one workbook to another

[sth289]

Hello,

I've two workbooks and one of them is a stock workbook that has new stocks once every week. In the stock workbook It needs to copy starting from (A2:J2) to the other workbook sheet1(A2),then (A3:J3) to sheet2(A2) and all the way to sheet100 (A2).

However, if by any chance that copying the next line has the same order number they will be place in the same sheet instead of seperate sheets.

Thanks

 

[sth289]

Bump