atw: Merging Excel workbooks

Hello all,
I have an Excel problem. Someone at work mistook me for an Excel guru.
They want to merge 35 spreadsheets into one excel document.
As a combined document the total rows would come to between 3,000-4,000
- well within Excel's capacity. 
Excel does not appear to have the Insert File option Word does which
allows you to append files. 
Searched the Help but could only find "Troubleshooting merging
workbooks" which is no help.
 
regards,
Matilda
 
 
 

-----------------------------------------------------------
Sydney Water - Winner of the 2006 Stockholm Industry Water Award
 -----------------------------------------------------------

NOTICE: This email is confidential. If you are not the nominated 
recipient, please immediately delete this email, destroy all copies, and 
inform the sender. Sydney Water Corporation (Sydney Water) 
prohibits the unauthorised copying or distribution of this email. This 
email does not necessarily express the views of Sydney Water. 
Sydney Water does not warrant nor guarantee that this email 
communication is free from errors, virus, interception or interference.
-----------------------------------------------------------

Other related posts: