Macro to find last entry in a series and count number

Hi,

I have uploaded a sample spreadsheet with what I am trying to do. I want to get a list of the last chapter(f) of each book (a) I have highlighted the ones that I am interested in in yellow. I want to get a list of them with the number of times each appears. This is made difficult for me as the number of chapters in each book varies so the position of the last chapter for each book varies in the worksheet each time. I have conditional formatting on to make the worksheet look as it does now and don't know if this might help?

Basically I would like to see

Birch 2
Oak 1
Beech 1
Pine 1

but obviously my document is much larger at around 30,000 rows so it's far to large to carry this out manually.

Very grateful for any help