Thanks Nick. However, the big operator in my question is "newbie".
DataConsolidate seems likely, of course, but nothing that comes up after
making that selection makes sense.

I'm not an MVP, jsut a newbie. Which function, what source, etc. . .?

Anybody out there willing to be a bit more explicit and thorough?

"Nick Hodge" wrote:

Johnny

You could try DataConsolidate...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Johnny T" <Johnny wrote in message
...
Sorry for the newbie question, but. . .I have data in a workbook on 10
worksheets. All are formatted identically, and I would like to combine
the
10 worksheets into a master worksheet--number 11. How can I do this
without
having to go in and cut and paste?

thanks for your help.