How to Combine various worksheets...

Hi,
I'm new here so bare with me. I'm trying to find out how to combine various worksheets from multiple workbooks into one workbook. At first I thought I could do this usually AppleScript (don't hate) but I keep getting stuck by the fact that I can't save the worksheets to the same workbook. I have no knowledge of how VBA works, so I'm turning here.

What I need is worksheets from multiple workbooks (all different file names) condensed into one workbook.

Thanks in advance,
Ely

I have multiple worksheets, all from different workbooks (different files), that need to be combined into one workbook, not worksheet. I think thats about as clear as I can make it.
(Ex. Workbook 1 contains worksheet A, Workbook 2 contains worksheet B, workbook 3 contains worksheet C. I need Workbook X containing worksheet A,B,C, etc.)

Thanks!
Ely