Hi all

I'm tyring to write some VBA to copy data from 10 wbs and paste it in a long list one after the other in a different wb on one sheet.
Copy ranges A2:A34, H2:H34, L2:O34
Sheet “Project 1(SPT)”
In wbs: 7aIt1, 7aIt2, 7aIt3, 7aIt4, 7aIt5, 7bIt1, 7bIt2, 7bIt3, 7bIt4, 7bIt5
AND

To wb: “2013-14 Autumn KS3 SPT”
Sheet: “Upload Data”
In Columns A:F

Directory T:\Common Area\ICT\Tracking\New Y7

Does anyone have any suggestions on how to do this?