Hope someone can help

What I want to do is have a macro that copies the same cells from 10 different specifically named excel files and pastes them onto the relevant worksheet within another workbook. All the files will be within 1 folder.

Hope this makes sence and someone can help.

Thanks