Create folders and sub folders from lists of data in excel

Hi All

I know this topic has been covered but I cannot see anything that answers my particular query so I am hoping you can help.

In my parent directory of 'Renewal Reviews' I want to create a list of folders based on a list in column A. Within each folder created from the list in column A I want to create 5 sub folders titled: 2016, 2017, 2018, 2019, 2020. Then, within each of the yearly sub folders I would like to create sub folders based on a list in Column B.

So it should look like this:

AGENCY NAME (column A) > 2016 > CLIENT NAME (Column B)
AGENCY NAME (column A) > 2017 > CLIENT NAME (Column B)
AGENCY NAME (column A) > 2018 > CLIENT NAME (Column B)

Hope this makes sense and hope you can help!

Thanks.

Yes they are sorry. They are different counties. And obviously the client names are all unique.

Any ideas at all?