First thoughts are that:
1) Your administrator saves the attachments preferably, but not necessarily, to a standard directory;
2) She opens the myWorkbook book and runs a macro from a button or drop down menu which:
a) Displays the Excel 'File Open' form to select a file to open;
b) Opens the selected file;
c) Copies any data in Sheet1 of the workbook opened to the next available row in myWorkbook;
d) Copies down the formulas already in columns H-P to the end of the new data;
e) Closes the import workbook;
f) Returns to (a) to prompt for the next template to read, which can be cancelled if there are no others.
If this is the sort of thing you are looking for, I can give you some code that will get you started.