I have a folder of identical excel files that act as a forms. I need to run a macro over the folder that extracts the same data from *** the files and puts them into a database.

In the new workbook each row will be a form/file from the folder and the columns will have the information from the identical forms.

Any help much appreciated.

Thanks

Mike