While it would be a lotta' work, I would suggest that you maintain a master
workbook w/30 workhsheet with each sheet dedicated to each of the 30
workbooks you need to assemble. No need to go get em' that way...
--
Kevin Backmann


"mttmwsn" wrote:

I need to get excel spreadsheets from 30 people once a week.
Instead of having the spreadsheets e-mailed to me, I need to automate the
process. I thought about seting up an ftp site but we have the budget for a
better solution. MS SharePoint seems like overkill because it's not a
collaborative project. I just want to get their data and also possibly let
them correct their data if they make a mistake.