the reference references responses to hundreds of posts asking questions on
either consolidating multiple sheets or multiple workbooks.

You should find a solution that fits your needs within the list.

--
Regards,
Tom Ogilvy

"Rob" wrote in message
...
Tom,
Thank you for the assistance.
I should have said multiple workbooks instead of multiple worksheets.
Will
the macro you referenced work for multiple workbooks as well? I need
information from the first spreadsheet of 50 different workbooks put on
the
first spreadsheet of one workbook.

"Tom Ogilvy" wrote:

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 multiple spreadsheets each week as part of a survey. I need
to
consolidate several of the fields onto one spreadsheet. How can I use
VBA/macro/function to consolidate the information from several
spreadsheets
to one spreadsheet without having to open all the spreadsheets?
Thank you.