Need a Macro
 

Hi, I want a macro with which I'm able to copy some data from different file which placed at a different location.

In brief,

I've 10 excel file located at different location. I want to collect data from those 10 files and make one consolidate file.