VB macro to load/copy/paste multiple files into one spreadsheet.
 

I am trying to write a macro to get information from several
spreadsheets in the same folder.

The issue is how do I get excel to return a list of all the spreadsheet
names and then step though each and perform the same actions -
essentially copying and pasting - into a Master spreadsheet?


Any help would be much appreciated,

Thanks

Fred