Collating multiple worksheets to one worksheet

Hi,

I am going to have 16 users have their own workbook with one worksheet that they will complete daily. There will be 12 columns and at COB will be up to 100 rows.

When everyone leaves I need to move all of this data from each workbook to one 'master' worksheet.

Have anyone any ideas on how I can do this so that I can be sure everything has been moved correctly?

The only way I can think of is cutting and pasting from one at a time.

Is it possible for a Macro to do this?

Thanks