Worksheet know-how!

[Erebus]

Please can you help?

Part of a Moodle (VLE) project I am currently working on invloves the use of an Excel workbook. The excel workbook in question comprises 35worksheets: the first "sheet" contains a column of 34 dates and a column of 34 corresponding Topics. (and other related information) The remaining worksheets 2-35 will contain "data" taken from the two columns in sheet 1.

PROBLEM
I want to copy the first date and its corresponding topic to sheet 2, the second date and its corresponding topic to sheet 3 and ...... so on. How can I do this in one fell swoop without having to go through each worksheet individually and placing formula in the appropriate cells. It goes without saying but I have only a very basic working knowledge of excel!! Any advice: methods techniques, formula, commands would be greatly appreciated.... the simpler the better

Many thanks Rick (excel novice!!)

[mrice]

Can you supply an attachment for greater clarity?