I'm setting up a database using several excel sheets (at the current time access is not an option). all of the sheets have to report to one master sheet. I don't want the master to have to reference all of the other sheets, because the file names change every 44 days. I would like to know if it's possible to have data in one sheet sent to another sheet rather than the second sheet simply referencing it? If it is possible, it it possible for excel 2003.

Gene