Consolidating Data from many workbooks

Hi,

I have a large number of workbooks, each with data in columns A to C of Sheet1. The size of the range A:C differs from workbook to workbook by the number of rows.

I would like to consolidate the data from each Sheet1 of each file into a range A:C in Sheet1 of a new workbook.

Can someone please suggest how I can do this?

Thanks very much!