Doing this from Word is fraught with difficulty. For one thing, it is likely to fall over if anyone else has the workbook open. For another, what are you going to do if a user presses the submit button more than once - even on different dates (e.g. to correct an error - including an incomplete form - or because originally-correct data needs updating)?

Far better, IMHO, would be a process that exports the Word data as a text file to a specified directory (thus ensuring updates overwrite the original), and have a separate Excel macro that imports all data from that folder, overwriting whatever data are already present.