How do I transfer data from multiple sheets to one without pasting
 

In Excel 2003, I want to consolidate multiple worksheets into one without any
operations such as sum, etc. The database will be added to, so it would be
good if the consolidated sheet could update itself.