merge multiple worksheets into one

[ge0rge]

I have a worbook with worksheets named as 1-22-08, 1-23-08, 1-24-08, etc..

They are identical as far as setup. How can I merge them together easier into one sheet rather than cut-paste, cut-paste, cut-paste....I think you get my point. There has to be a better way I just can't find or figure one out. Thanks for looking!!

Back to looking for the answer!

[sglife]

Was the data type and location inside each sheet same
Is there any common colums or rows in each sheet?
I can use VBA code to do this, but first I must have the file

[arthurbr]

hi,
would this solution be what you need?

[ge0rge]

Thanks for the reply. I found a tool before anyone responded called Convert XLS and it did what I needed. I am still going to try your suggestion. Thanks.

[arthurbr]

Thx for the feedback and for sharing your solution !