Hi Ron

in terms of the process, yes that?s correct, its basically a way of reporting on what?s been achieved each day by the individuals submitting the reports.

The names of the new workbooks at present are the individuals name eg Carlie followed by the date the report refers to. However this could potentially change if required as a degree of manual work is needed to save the files initially from my emails.

The target worksheet names do already exist within the template and the cells copied need pasting to the following destination: D16:F57 within each of their relative names worksheets

The source folders are moved into a specific folder for storing however i cant tell you the address as every time i try to submit the message it tells me i dont have enough posts although this the location is not particularly important.

In terms of saving the new compiled workbook to a folder that sounds like a good idea but am not overly fussed on the location

Food for thought

Missing files: there will be missing files, due to staff absences, we have a very simple excel function running that indicates which are missing. This is satisfactory

Yes there is potential for all the number and names of people to change although I feel I will have to deal with as a separate project