Hey Guys,

This is my first time using VBA so I'd be really grateful for any help/advice. I've done a few online tutorials so have learnt the basics but this is my first project as such.

I'm looking to create a code which is able to copy data out of one file and place into a summary folder.

For example, I have files such as 1056, 1057 through to 1186. Within these workbooks, I need to copy data out of a sheet which the name is velocity and the data is in cells C617. It would great to also put the file name above the data. The data needs copied into a new workbook which is called summary.

Any help to get me up and running with this project would be greatly appreciated,

Thank you