Do some Excel Work

I would like to set up a spreadsheet with a dropdown menu selection option across seven columns (columns B-H) in an excel spreadsheet. The list of items that need to be on a dropdown menu selection shown under each header on the attached spreadsheet. I need every box/line under the header in the column to have the dropdown option. The purpose of the spreadsheet is that you will enter information in columns I to Q and tag it across each of these seven columns B-H using the drop down menu in each box on that data line.