problem with import files by excel macro
 

Hello,

I need to write/record a macro that takes multiple files(UNIX files)
and then copy all their content back to a sheet of the excel and then
manipulate the data to generate a report. I particularly need help with
macros that can import multiple files. I have come across an excel
application whose button can prompt a windows and import ONE file to do
similiar thing. However, what I want to do is more sophisticated. Do
you have any idea?? do you have any resources from the web?? Thx!!