Append multiple worksheets into single worksheet

Ok so had a quick search around and could not quite find what I am after but if it is there point me over.

I have some data entry people, currently they create a new daily workbook for each day, using only a single worksheet in each workbook. They then at the end of each reporting period do a cut and patse of the five daily worksheets into a single weekly summary workbook and worksheet.

I would like their to be a situation where they either still use a daily workbook or use different sheets (slaves) in the same workbook. But all this information is appended/joined into a single worksheet either in the same or a different workbook each time it is opened or by activating a macro.

I know this must have been done before, anyone got some ideas?

Thanks inadvance,
Steve

Welcome to the board

maybe you will find what you need here : http://www.rondebruin.nl/tips.htm
under Copy/Paste/Merge examples