macro to copy data from 3 worksheets in one worksheet

This locks in the starting cell. Change to F

.Range("E2",

and this part shows it ending in Col F, Change to G

.Range("F" &

and finally this parts find the last cell in Col F

Rows.Count).End(xlUp)).

So if the last cell in Col F is F100 the full code would copy the range E2:F100

HTH

VBA Noob