Hello!

We are using an Excel workbook/worksheet as an Event/appointment book. Each
user has his own workbook. The workbook contains one worksheet were one row
1 there is some headers and on row 2 the actual data begins. The data can
be any number of rows.

The headers a
Event,Date,Time,Place,Price,Note

Now I want to combine/merge all the 'user workbooks' into an 'all users
workbook'. Were the user data will be appended into the 'all users
workbook' and then sorted on Date and Time.

I want to do this using a Macro so that I can link the macro to a button.

Please help!

// Anders