I must say this was challenging but fun. This challenge introduce me to hands-on drop down and macro and figuring out how to configure it all but finally got the output.
Although I had the workflow to work out but I also had to debug my workflow before hand to get the output to work properly.