Create worksheet with a list,and fill the worksheet from another

pencari Posts 2 Registration date Wednesday November 5, 2014 Status Member Last seen November 6, 2014 - Nov 5, 2014 at 11:44 PM
hi all,
i want to ask..

if i want to create a worksheet with a list from sheet1, begin from b2, i figgured this out with macro from

when the sheet created, i want to format the sheet that has been created with the list from another worksheet that i have make... can some one help me?