i want to import data from one workbook to another and add a row
 

I have a workbook with one spreadsheet that I want to import data from
various other workbooks/files containing the same information. I want this
one to add a row for each file imported and not overwrite previously
entered/imported material. Thus this would create a master database.