pulling data from one workbook to a sheet of another workbook

Could anybody help a brotha out?
I have excel workbook called that has a tab called "master" that is populated with data from seperate excel workbooks (up 50 different ones!). I only need to copy some of the data from source into the "master" sheet. Here's what I'm trying to accomplish
First Data Set
copy all data from column A3 until the words "Grand Totals:" (this varies from 1 row all the way to 500 rows) from source to first empty cell under column "c" in "master"
Second Data Set
copy data from U1 in source to first empty cell under column "B" in "master"
Third Data Set
copy data from G1 in source to first empty cell under column "A" in "master"


One more thing, the workbook that contains the "master" tab will be a new file name every two weeks.

Any ideas?

Um ....wow

Almost seems like you need a database app to me ....

can you post an example please?

sure in the source spreadsheet (which I will choose, doesn't have to automated) I would like to copy all the data from a3 to j5 (again on some files this will be multiple rows) to the first empty cell in column C in the master.

Does that help?

Is there a way I can attach the actual files? If not I can email them.

thanks!

oops, just saw the "advanced tab

step 1
ok in the file d9878.xls I want to copy all the data from a3 to j5 (or until "Grand Totals:") to the first empty cell in column "c" in master tab of "se balances 11-24-10 data test.xls".

step 2
then i want to copy data from U1 in d9878.xls to first empty cell under column "B" in master tab of "se balances 11-24-10 data test.xls".

step 3
then i want to copy data from G1 in d9878.xls to first empty cell under column "A" in master tab of "se balances 11-24-10 data test.xls".


It would also be nice if the data filled-in the same number of rows in step #1.