getting multiple data to populate another worksheet
 

Hi,

I hope someone can help me.

I am trying to set up some information relating to business performance.

My worksheets a
New Business Register, 6.1.05, 13.1.05, 20.1.05 etc up to the end of the year.

The columns on the New Business Register worksheet a
Name, Date Sold, Mortgage, Client Fee, Life, Health, B Ins, C Ins, AS
ins, U Ins, Total Commission.

The Cloumns on the weekly tabs dated 6.1.05 onwards a
Name, Date Sold, Mortgage, Client Fee, Life, Health, B Ins, C Ins,
AS Ins, U Ins,

What I am looking for this to do, is get information from the new business
register to prepopulate the weekly sheets, but my problem is that all of the
information tries to populate the same cell in the worksheet.

example of what I need to do.

every time I enter a client name onto the new business register with a date
which is between 01.1.05 and 06.1.05 it will automatically populate the sheet
titled 6.1.05 with the clients name and the other details I have entered.

I then want it to populate the next row down if I enter any extra clients
that were sold to within the timeframe, or to populate the sheet to which the
date corresponds.

I don't know whether this makes much sense, or whether there is a more
logical way of approaching this. PLS HELP!