collating data

Originally Posted by ~Lews Therin~

what is the best way to collect selected data from several different workbooks, that will be updated daily, into the one spreadsheet. each day it is updated, the new data is to be stored in the cells below the previous days data.

the data from the original workbooks always comes from the same cells.

I would create a macro that pastes data below the lastrow of yesterday's data.

Do you have a sample document?