Combining Multiple Worksheets and/or Multiple Workbooks

[bosstone75]

Hello,

I've searched around and I'm having difficulty finding an answer for what I would think would be a relatively simple and common problem.

I have a user who has created multiple worksheets AND multiple workbooks with multiple worksheets (don't ask me why).

All the worksheets have exactly the same columns headings, so I could do a copy and paste, but I would have to do that for a hundred different worksheets.

2 questions...

Is there a quick and easy way to basically copy and paste all of the information currently contained in multiple worksheets into one worksheet?

ALSO

Is there a way to do the same thing across multiple workbooks? If you can only answer question one, it wouldn't be hard for me then to manually cut and paste across workbooks once I have the worksheets combined.

I haven't had any experience with Macros or VBA, so if you talk about that, I'll need a bit of extra support.

Thanks!
Bill

 

[GGJstudios]

You haven't said what operating system you're running: Mac OS X or Windows.
You haven't said what application you're using: MS Excel or Numbers.
You haven't said which version you're running.

 

[bosstone75]

Sorry and thanks.

I'm on a Mac 10.5.4
I'm using Excel 12.2.3 (version 2008)

 

[GGJstudios]

Excel 2008 doesn't support VBA or macros, so you'll have to do it manually.