open multiple files as defined on sheet?

[endholcisitu]

hi guys.
kindly need your generous assistance for creating macro to open multiple files on particular folder. Whereas the file names should be opened are defined first on a worksheet. Then, i want to combine/merge the content of each file (all in sheet1) on different single sheet as summary. Is it possible?

Thanks..may your days be filled with joy and happiness...