VBA Copy and Paste Loop Help

[sabertstxvii]

Hey all,

Long time lurker, first time poster.

I always try and find my answers before asking, but my mind is in a meatball in this one as I have very little VBA experience.

I have a workbook with essentially 3 columns that are important.

Sheet 1: Has the data that I need to input into Sheet 2.
Sheet 2: Has all of the formulas that autopopulate all of the data I need to copy onto Sheet 3.
Sheet 3: Just where I want to house all of the data from the formulas that auto populate from sheet 2.

To make this example easiest, assume on Sheet 1, Column B and Column E I have 25 rows of data. I need to copy Row B1 and E1 into Sheet 2. Once in Sheet 2, I need to copy D3, E4, J6, L7 and F10, G10 into Sheet 3. Then I need to go back to Sheet 1, and start over with the loop and do B2 and E2 back to Sheet 2...and continue until there are no rows left in sheet 1.

Help! Thanks in advance.

 

[sabertstxvii]

Sorry 2 typos that may help clarify:

1. I have a workbook with essentially 3 SHEETS that are important....

2. assume on Sheet 1, there are 25 rows of data. I need to copy CELL B1 and E1.

 

[sabertstxvii]

Bump - any thoughts?! Thank you so much.