Do a Google with search term <excel consolidate
Then, if needed, come back but tell us more about the layout of the
worksheets.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"iamoktc" wrote in message
...
I have 17 seperate worksheets in one book. I now want to combine all that
information, which is in identical format, onto one worksheet.