If you just mean append the information down a single sheet, then just
search google groups for consolidate


http://groups.google.co.uk/groups?as...ng&lr=&hl=e n


the URL should all be on one line

--
Regards,
Tom Ogilvy
"Rob" wrote in message
...
I receive about 50 spreadsheets a week for a survey. I need to
consolidate
the information into one spreadsheet. How can I crete a macro/formula/vba
script which will automate this process so that I don't have to open the
50
spreadsheets? Thank you.