I need to design an excel model which will import data from an external
database when I enter a date into a cell in the worksheet.

This is to avoid having to manually key data each month i.e. into a profit &
loss report.

Can anyone point me in the right direction - I don't know where to start -
or even if this can be done.

I'd be grateful for any advice - I'm having sleepless nights!!