data...idea/thoughts

[jw01]

hello all

i have this massive task ahead of me and i was wondering if i can get some input/advice on how i should approach this task...

i will be receiving 180 workbooks. there is a sheet called "weekly update" with approx. 100 rows of data. the worksheet name and # of rows is consistent in all workbook.

i need to roll this from 180 seperate workbooks into one consolidated workbook "master"....

what is the best method to do this task?
-excel indirect.ext?
-access?

thoughts/suggestions? pls and thx u