Excel 2007 : Next Row Loop - Copy Paste

Ok what i am doing is i have a list of data, Column A is the sheet name (which is also the part number) and columb B-E is Date, QTY IN, QTY OUT, and PO Number. I would like this macro to go down my list and

Copy data in B, C, D, and E and paste it to the sheet that is in column A.

of course it needs to do B2-E2 into the sheet in A2

then move on to B3-E3 into the sheet in A3

Please Login or Register  to view this content.

but instead of referencing cell A2 and B2 everytime i need to make it apply to the row its on. i assume i would us something with an offset but im not sure how to use those. thanks for any help!

MR EXCEL POST
http://www.mrexcel.com/forum/showthr...67#post2500567