I would use Access rather than Excel.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Kevin J Prince" wrote in message
...
Thanks,
I think that means in real terms a 63 worksheet GRIN...
so that gives me another question...

Is there a quick way to actually grab cells C33 and F4 on each of the
worksheets and place them on a fresh worksheet in three columns (third one
would be the date from A3 & A9 ) Do I have to get into some form of VBA to
do this? Date form would be '3-May-2006 to 9-May-2006'
Or
Some way of automatically filling in the new worksheet every time the
information is entered on the Weekly sheet?

Just trying to make the whole thing simpler!

Regards Kevin



In message , Doug Robbins - Word
MVP writes
Word can only use one sheet as the mailmerge data source. Therefore you
will need to add another sheet to the file and on it reference in a column
for each week, the cells C33 and F4 from the other 52 sheets and then use
that sheet as the data source for the mail merge.


--
Kevin J Prince