I also have a similar problem to this and I am a complete Excel novice.

My Excel 2007 version workbook currently contains 18 worksheets, 1 of which
is a Master Sheet, that contain mainly Date based staff Certification info
(eg: 25/02/2009,16/01/2009, 18/02/2008) and I am wanting copy the
Certification dates pertaining to each individual person's tasks that they
are certified for from the other 17 worksheets into the corresponding columns
& cells in the Master sheet and be auto updating as the data changes in the
other worksheets.
Unfortunately the 17 worksheets need to be kept as individual sheets.

To complicate things further, I need to maintain compatibility with Excel
2000 SP1, Excel 2003 as well as Excel 2007 versions as we have a mixture of
all 3 versions on the network.

Hopefully somebody can help me here?

--

mclwlg