multiple fies updating one file

Giganews Newsgroups
Subject: multiple fies updating one file
Posted by:  Vic Abrahamian
Date: Wed, 4 Mar 2009

How would I setup an excel sheet that needs to collect numbers from other
excel sheets. The rows and fields numbers will keep growing.
I know how to reference a cell in a file but not sure how you can quickly
create a reference to a range of cells and how about when the range keeps
Thank you