I'm new to Excel so I'm not even sure this is possible.

What I'm trying to do is set up a workbook to record our family’s
bank/monthly transactions.

My question is, I've set up a drop down list for the different categories
(i.e. Household bills, Vehicles etc), is it possible that when the category
is selected in the monthly worksheet, the date, description, and debit can be
automatically copied into the Category worksheet?

The drop down list is in the monthly statements worksheets, and I'd like the
categories to be yearly.

I’m sure it could be done in VB, but that all looks Greek to me.

Any help would be greatly appreciated, and possibly prevent a brain aneurism!