Copy dynamic range to a sheet in new workbook with specific format

Cross Posted here:
https://www.excelforum.com/excel-pro...ml#post5077492
https://www.mrexcel.com/forum/excel-...ic-format.html

Hi,

You can see 2 sections in my attached excel file. Section-1 is the sheet in source workbook and Section-2 is the destination sheet to be copied in a new workbook. I need a vba to copy the required data in a dynamic range from Section-1 (sheet1) to Section-2 (new sheet) with specific format in Section-2. The essentials are defined in attached file as well.

Thanks in advance for kindest helps.