macro to merge workbooks
 

I need a way to merge up to 15 worksheets into one workbook. Can this be
done on a time schedule? Say everyday at midnight go out and get all 15
worksheets and copy them to 1 workbook. Is a macro the best approach or can
this be done through scripting?

thanks for input
Mike