Open the workbook
Alt+F11 to the VB editor
Insert / Module
Paste in the code

You will need to adjust the names like "Detail2.xls" in the code, of
course.

Auto_Open will run automatically when you open the workbook.
To test it you can just use Tools / Macro / Macros / Auto_Open / Run

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup