rugbyfitz,

Summarizing: you receive 15 workbooks each day, copy the selected range from the 'compiled' worksheet of each workbook and paste it to a separate worksheet in the new 'compiled' workbook. Tomorrow, youi'll receive another 15 workbooks and repeat the process.

What are the names of the source workbooks? Is there a naming convention that you use for source and target workbooks? Do the target worksheet names already exist in the template workbook or should the process create them? Do you move the source workbooks into a specific folder for processing? Is the master copy of the target workbook kept in a particular folder? Do you want the new 'compiled' workbook saved to a particular folder?

Food for thought (and future modifications):
What do you want to do about a missing source workbook? How often do the people reporting to you change? Might the number reporting increase?