dropdown list to insert multiple columns from one sheet to another

[lecnad]

Guys I need your help either vba code, excel formula or steps in creating my template. for instance i have workbook with 4 sheets(1,2,3,4) and every sheet(2,3,4) has 3 columns. Now i want to create in sheet1 a group of columns. For the first three columns i want a dropdown list say, s2,s3,s4, and if i pick s3, it will copy the values/formula on the three columns from sheet3 and doing the same thing for the next 3 columns and so on. Is this possible to do or are there any alternatives? Thank you. Any help is appreciated