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" <[email protected]> wrote in message
news:[email protected]...
> 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...ming&lr=&hl=en
> >
> >
> > the URL should all be on one line
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Rob" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
> >
> >
> >