Combining Multiple Worksheets and/or Multiple Workbooks

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

 

Sorry and thanks.

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