Linking several worksheets to a results sheet

Hi,
I have several worksheets in a workbook, and I want to be able to include a worksheet that includes the results from similar cells in each worksheet, for instance have a column for the C1 cells from each of the other worksheets, another for D6 etc. hopefully this would save the long task of collating and adding up each lot of data.
Also, is it possible to insert into the ‘results’ worksheet, the other worksheet names automatically? I have used the date and then A, B etc. IE 030609A, 030609B, any help would be appreciated,

Phil