I don't know if this can be done but I enter details of payments made
on three sheetst.

Sheets called 3A 3B and 3C the information on each sheet is different
but the payments received are the same so I enter the date and amount
under separate columns for cheques and cash

The columns I have on these three sheets are:

surname first name date cheque cash

and I need to details of the names and banking on sheet four on a
daily basis.

So if I am enter four entries onto sheet 3A with todays date I would
like them to appear on sheet four automatically for banking but only
if the entry in column b is new (i.e. today's date)

Can I do this?

Thank you

Wendy