Another challenge,

Probably biting off more then I can chew but what the
heck..

I have over a hundred excel files with data in maybe
twenty cells on each "sheet1"

I would like to gather that data into one master
spreadsheet. Any suggestions?

I know I can just "link" the cells to the master
spreadsheet but I was looking for a better way to do this?

I know there are few details her but if someone is
interested in discussing this I would be happy to share
more details of what I am trying to accomplish.

Kelly