Combine Excel Sheets from folder into 1 book

Hi Ya,

I have a number of workbooks in a folder which I would like to combine certain cells of them into another spreadsheet. The cells I need from the work books are in different sheets but are the same for every work book. I then need to show the data in the new spreadsheet in a table format - can anyone help??

Many Thanks

Rebecca

PS I have Excel 2007