Drop down menu,s on Excel

Hi All

I am creating a new speadsheet for use in my work and I am trying to set up drop down lists in each column showing a list where one click will enter the required data from that list into the cell

I have created the lists to go into these drop down menu's on a second page of the workbook and need help with getting them onto the main sheet as drop down menu's

Basically one column is drivers names the next is vehicle registrations and so one.

Can anyone help me out here please....