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.