Count Number of Files in Different folders

[caabdul]

Hello Excel Heroes

I am back with a new problem.

Here is the scenario;
> There are many folders in "D:\" on the names of animals.
> In each folder, there are images named as 1.jpg, 2.jpg, 3.jpg and so on.
> Each folder contains only these image files and may contain 1 to 7 images.

> In my excel file, column A contains the names of animals (same names folders exist in "D:\".
> In Column B, I want number of images present in each folder. For example, if Cell A2 contains "Rabbit" then cell B2 should produce the number of images in folder "D:\Rabbit"

Is it something that is achievable? Ask if you need further clarification.

Thanks to all