Importing data from Multiple Excel files to one single Excel file

Hi All,

I am very new to this forum, need your support in the below mentioned query.

I want specific data ( say 5 individual cells) from various files ( all files of same format ) to be imported into another excel file.

Can any body have a solution how to do this???

Thanks
Guru