Excel dropdown box help

Hello,

I have 3 individual worksheets and 3 main worksheets,
I am looking to create a dropdown box for the 3 individual worksheets, the dropdown box should contain the names of the 3 main worksheets,
when a main worksheet is selected I want the data on the column to be extracted and go on the next available line on the main worksheet selected,
the column from which the data is extracted should then be deleted as if the column has been selected as hidden,

can anyone help me!!!