Trying to copy data from multiple sheets to a new sheet in 1 workbook (EXCEL 2010)

I have several workbooks that are very similar... other than they have a different number of worksheets with data in them.
Each worksheet has a different name (Not sheet 1, sheet2.... etc) indicating the data conditions.

I'd like to learn how to write a macro that will take a cell range - which is always the same in each worksheet - from each
of the worksheets and put it on another "summary" worksheet.

All workbooks do not need to be "processed" at the same time. I just mentioned that I have several workbooks because
there is always a different number of worksheets I'd like to be able to use the same macro for (if that is possible).

Thanks!
Michelle