Simple Spreadsheet consolidation - repost 5

I have several word docs and excel files with address that need to be put into specific fields in Excel. The Excel spreadsheet has the fields across the top in columns, exmp: Name, Address, City, State, Zip, etc Each of the approximate 80 addresses is in a separate word doc and other excel files and will need to be input into the spreadsheet going down the rows. Sorry had to update this at the last moment.